[postgis-users] PSQL 8.3

[Paul Ramsey]

The "magic upgrade" path...

1 - Compile and install PgSQL 8.3 and latest PostGIS.
2 - Inspect your old PgSQL / PostGIS installation. Find out what  
versions of liblwgeom you have. In your new installation, create  
symlinks so that the old files appear to exist in the new installation.
3 - Dump your old database. Don't do anything special, just dump the  
whole thing.
4 - Check and see if there are explicit paths to liblwgeom in the  
dump file. If there are, pass the file through sed and flip them to  
$libdir/liblwgeom.so.
5 - Create a blank database in your new instance. Do *not* install  
PostGIS.
6 - psql -f dumpfile the old database into the new instance. Cross  
fingers. Pray.

This works (for small enough version changes) because the new  
versions of PostGIS don't tend to change the internal function names  
of things, old PostGIS SQL can usually be linked against new versions  
of the library.

Run the soft upgrade process on your new database to clean up any  
remaining issues.

P.

On 4-Feb-08, at 3:18 PM, Gregory Williamson wrote:

> I ran postGIs with 8.3Beta (RC 2 and 3) and had no problems in  
> testing ... I didn't try the upgrade script.
>
> I dump the old database in 2 scripts, one data, one ddl. I edit the  
> ddl stuff to remove all postGIS functions and types, etc., and move  
> the index/constraint creation into a separate file. Create the 8.3  
> db, install the postGIS for it, rename the geometry_columns and  
> spatial_reference tables,run the DDL to build my tables, run the  
> script to add data, copy data & rename the geometry_columns and  
> spatial_reference tables so I have the right data in the right  
> tables, and finally run my DDL to create indexes and constraints.  
> Worked like a charm. Bit fiddly though.
>
> Be interested to hear if the upgrade path works.
>
> Greg W.
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net on behalf of  
> Dylan Beaudette
> Sent: Mon 2/4/2008 4:14 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] PSQL 8.3
>
> Anyone tried out PostGIS on the latest release:
>
> http://www.postgresql.org/about/press/presskit83
>
> ??
>
> I am still using 8.1.2- thinking of upgrading, but dreading postgis  
> "hard
> upgrade" path...
>
> Anyone tried this yet?
>
>
> --
> Dylan Beaudette
> Soil Resource Laboratory
> http://casoilresource.lawr.ucdavis.edu/
> University of California at Davis
> 530.754.7341
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users