[postgis-users] PSQL 8.3

[Gregory Williamson]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080204/dd3d7214/attachment.html>