[postgis-users] Question Upgrading to PostgreSQL8.2 PG1.2.1

Obe, Regina robe.dnd at cityofboston.gov
Wed Mar 7 14:00:11 PST 2007


I'm trying to think what version I had before 1.2.1.  I think it was
1.1.1 or perhaps even lower and I just did a soft upgrade.  I don't
recall running into any problems doing a soft upgrade.

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Randy George
Sent: Wednesday, March 07, 2007 4:31 PM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] Question Upgrading to PostgreSQL8.2 PG1.2.1



Hi,

 

            I have a question on upgrading to newer version of
PostgreSQL/PostGIS on Windows

 

Using:

Windows 2003

 

Old:

postgis_full_version

"POSTGIS=""1.1.1"" GEOS=""2.2.1-CAPI-1.0.1"" PROJ=""Rel. 4.4.9, 29 Oct
2004"" USE_STATS DBPROC=""0.3.0"" RELPROC=""1.1.1"" (needs proc
upgrade)"

 

New:

PostgreSQL 8.2.3 - postgresql-8.2.3-1

PostGIS 1.2.1 - postgis-pg82-setup-1.2.1-1.exe 

postgis_full_version

"POSTGIS=""1.2.1"" GEOS=""2.2.3-CAPI-1.1.1"" PROJ=""Rel. 4.5.0, 22 Oct
2006"" USE_STATS"

 

I assume that I need to do a hard upgrade. I am using the pgAdmin III
backup/restore for transferring dbs to the upgraded version.

In order to make this work I manually create each of the DBs in the new
version using the default template_postgis and then do a Restore from
the previously exported 8.1 .backup. This is a bit time consuming with
several large DBs like TIGER2005, NHD, DCW etc, but appears to work.

 

Looking over the restore log there are a number of warning/errors:

WARNING: errors ignored on restore: 364

Process returned exit code 1.

 

Most of the errors seem to be with the PostGIS functions which already
exist from create with template_postgis. For example:

pg_restore: creating FUNCTION geometry_analyze(internal)

pg_restore: [archiver (db)] Error from TOC entry 30; 1255 16421 FUNCTION
geometry_analyze(internal) postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  function
"geometry_analyze" already exists with same argument types

    Command was: CREATE FUNCTION geometry_analyze(internal) RETURNS
boolean

    AS '$libdir/liblwgeom.dll', 'LWGEOM_analyze'

    LANGUAGE c S...

 

In spite of the "exit code 1" the tables seem to be restored correctly
allowing my usual queries.

 

Note: I do need to add my custom spatial_ref_sys entries with sql
insert, since:

pg_restore: [archiver (db)] could not execute query: ERROR:  relation
"spatial_ref_sys" already exists

 

However, I am wondering if some issue will surface down the road due to
the ignored warning/errors? 

 

If there is a more efficient approach for transferring large DBs that
I'm missing, I'd like to know about it.

 

Also thanks for adding the asKML() function! These export functions
asGML, asSVG, asKML are really a help!

 

Thanks

randy

 

 

 




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070307/22d5e751/attachment.html>


More information about the postgis-users mailing list