[postgis-users] F18: Postgresql 9.2.x/PostGIS 1.5.x issues

[Devrim Gündüz]

Hi,

This is a known issue, and there is already a bugzilla entry about this. I hope to fix it in a few days,  by updating GeOS to 3.3.7 and PostGIS to 2.0.2.

Until then, you can use PostgreSQL RPM repo:

http://yum.postgresql.org

Regards, Devrim

Max Pyziur <pyz at brama.com> 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
>pyz at brama.com
>
>p.s. If I restore non-spatialized databases, those work correctly.
>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130124/10791f1c/attachment.html>