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@xxxxxxxxx
p.s. If I restore non-spatialized databases, those work correctly.
--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org
