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

[Paul Ramsey]

PostGIS doesn't require a hard upgrade from 1.1 -> 1.2.
PostgreSQL on the other hand, *does* require a hard upgrade from 8.1 to 8.2.

P

Obe, Regina wrote:
> 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.
> *
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632