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

[dustymugs]

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
> 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
>