The combination of PostgreSQL 9.2 and PostGIS 1.5 is not supported. http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
-bborie On 01/23/2013 03:56 PM, Max Pyziur wrote: > > > Greetings, > > I've done a fresh install of F18 on a Dell Latitude D630 laptop. > > Until now, most issues have been minor. > > I'm moving a large amount of Postgresql/PostGIS data from an older Dell > Inspiron 600m laptop running F17. > > I've run: > - postgresql-setup initdb > - systemctl start postgresql.service > - su - postgres > > and there proceed to run several items bundled into a shell script, > which reads as follows (don't know how to control line wrapping here): > #!/usr/bin/env bash > POSTGIS_SQL_PATH=`pg_config --sharedir`/contrib > createdb -E UTF8 template_postgis # Create the template spatial database. > createlang -d template_postgis plpgsql # Adding PLPGSQL language support. > psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE > datname='template_postgis';" > psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis-64-2.sql # Loading > the PostGIS SQL routines > psql -d template_postgis -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql > psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;" # > Enabling users to alter spatial tables. > psql -d template_postgis -c "GRANT ALL ON geography_columns TO PUBLIC;" > psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;" > > ######### > > The first problem was running > psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis-64-2.sql > > It gave me: > UPDATE 1 > SET > BEGIN > psql:/usr/share/pgsql/contrib/postgis-64.sql:59: ERROR: language "C" > does not exist > psql:/usr/share/pgsql/contrib/postgis-64.sql:65: ERROR: current > transaction is aborted, commands ignored until end of transaction block > > Now things are case-sensitive; globally replacing "LANGUAGE 'C'" with a > lower-case 'c' fixes that. > > Next problem: > UPDATE 1 > SET > BEGIN > psql:/usr/share/pgsql/contrib/postgis-64-2.sql:59: ERROR: incompatible > library "/usr/lib64/pgsql/postgis-1.5.so": version mismatch > DETAIL: Server is version 9.2, library is version 9.1. > > Now, I'm stumped. F18 ships w/ postgresql-9.2.2-1.fc18.x86_64 and > postgis-1.5.3-4.fc18.x86_64. > > I'd think that the two would jive, no? > > Any advice in this regard would be appreciated. > > Thanks. > > Max Pyziur > [email protected] > > p.s. If I restore non-spatialized databases, those work correctly. > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
