Upgrading to PostgreSQL 8.4.1 and PostGIS 1.4.0

View: New views

2 Messages — Rating Filter: Alert me

Upgrading to PostgreSQL 8.4.1 and PostGIS 1.4.0

by Moen, Paul T. :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have been trying to upgrade my PostgreSQL 8.3.8 to PostGIS 1.3.6 to PostgreSQL 8.4.1 and PostGIS 1.4.0

I first installed PostGIS 1.4.0 and upgraded each database with the command

psql -U postgres -d DBNAME -f postgis_upgrade.sql

I encountered the following notices.

psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:215: NOTICE: type "box3d_extent" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:219: NOTICE: argument type box3d_extent is only a shell

and

CREATE AGGREGATE
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2683: NOTICE: type "pgis_abs" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2687: NOTICE: argument type pgis_abs is only a shell

and

CREATE AGGREGATE
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2732: NOTICE: aggregate accum_old(geometry) does not exist, skipping
DROP AGGREGATE
CREATE AGGREGATE
psql:/usr/local/pgsql/share/contrib/postgis_upgrade.sql:2738: NOTICE: aggregate st_accum_old(geometry) does not exist, skipping

I assumed these were fine and moved on to the full dump using pg_dumpall -U postgres -o > full83dump.sql

I then installed PostgreSQL-8.4.1 and PostGIS-1.4.0 and load the data with psql -U postgres -f full83dump.sql.

I get the following errors as each of the databases are loaded.

psql:full83dump.sql:366: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:369: ERROR: function public.st_histogram2d_in(cstring) does not exist

psql:full83dump.sql:377: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:380: ERROR: function public.st_histogram2d_out(histogram2d) does not exist

psql:full83dump.sql:392: ERROR: function st_histogram2d_in(cstring) does not exist

psql:full83dump.sql:502: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:505: ERROR: function public._st_asgml(integer, geometry, integer) does not exist

psql:full83dump.sql:1509: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:1512: ERROR: function public.build_histogram2d(histogram2d, text, text) does not exist

psql:full83dump.sql:1525: ERROR: PL/pgSQL functions cannot return type histogram2d

psql:full83dump.sql:1528: ERROR: function public.build_histogram2d(histogram2d, text, text, text) does not exist

psql:full83dump.sql:1757: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:1760: ERROR: function public.create_histogram2d(box2d, integer) does not exist

psql:full83dump.sql:2077: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:2080: ERROR: function public.dump(geometry) does not exist

psql:full83dump.sql:2191: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:2194: ERROR: function public.estimate_histogram2d(histogram2d, box2d) does not exist

psql:full83dump.sql:2257: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:2260: ERROR: function public.explode_histogram2d(histogram2d, text) does not exist

psql:full83dump.sql:3105: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:3108: ERROR: function public.histogram2d_in(cstring) does not exist

psql:full83dump.sql:3116: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:3119: ERROR: function public.histogram2d_out(histogram2d) does not exist

psql:full83dump.sql:3215: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:3218: ERROR: function public.jtsnoop(geometry) does not exist

psql:full83dump.sql:4976: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:4979: ERROR: function public.postgis_jts_version() does not exist

psql:full83dump.sql:6215: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:6218: ERROR: function public.st_build_histogram2d(histogram2d, text, text) does not exist

psql:full83dump.sql:6231: ERROR: PL/pgSQL functions cannot return type histogram2d

psql:full83dump.sql:6234: ERROR: function public.st_build_histogram2d(histogram2d, text, text, text) does not exist

psql:full83dump.sql:6440: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:6443: ERROR: function public.st_create_histogram2d(box2d, integer) does not exist

psql:full83dump.sql:6638: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:6641: ERROR: function public.st_estimate_histogram2d(histogram2d, box2d) does not exist

psql:full83dump.sql:6704: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:6707: ERROR: function public.st_explode_histogram2d(histogram2d, text) does not exist

psql:full83dump.sql:9070: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:9073: ERROR: function public.st_text(boolean) does not exist

psql:full83dump.sql:9379: ERROR: could not access file "$libdir/liblwgeom": No such file or directory

psql:full83dump.sql:9382: ERROR: function public.text(boolean) does not exist

I compared the upgraded databases to a new one created via the createdb, createlang, psql -f postgis.sql and found a couple of differences.

The upgraded version is missing the dump(geometry) function.
The upgraded version has 2 extra functions, update_geometry_stats(),update_geometry_stats(character varying,character varying) that do not exist in new database I created. I believe these were used in upgrades from Postgresql 7.4 and lower so I should just drop these.

I see that in Ticket #144 most of the functions above are listed as a non-issue.

Am I correct in proceeding without worrying about the above errors? Do I need to do a hard upgrade instead? If so, should I use the new_postgis_restore.pl script? I have found no information in the documentation about this new script.

Thanks for any insight,

Paul

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: Upgrading to PostgreSQL 8.4.1 and PostGIS 1.4.0

by Paragon Corporation-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Paul,

As long as you have an ST_Dump function you should be fine. The dump function is deprecated and will be removed in PostGIS 2.0. As you stated, you can remove those additonal functions you see. The upgrade script currently doesn't drop functions, it just adds new ones.

The other notices as you noted are expected from an upgrade. You don't need to do a hard upgrade.

Hope that helps,

Regina

From: postgis-users-bounces@... [mailto:postgis-users-bounces@...] On Behalf Of Moen, Paul T.
Sent: Wednesday, October 21, 2009 5:37 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Upgrading to PostgreSQL 8.4.1 and PostGIS 1.4.0