F18: Postgresql 9.2.x/PostGIS 1.5.x issues

Max Pyziur pyz at brama.com
Wed Jan 23 23:54:57 UTC 2013


Greetings,

I've done a fresh install 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.

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
pyz at brama.com

p.s. If I restore non-spatialized databases, those work correctly.



More information about the users mailing list