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@brama.com
p.s. If I restore non-spatialized databases, those work correctly.