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: [EMAIL PROTECTED] on behalf of
Dylan Beaudette
Sent: Mon 2/4/2008 4:14 PM
To: [email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
