<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] PSQL 8.3</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>I ran postGIs with 8.3Beta (RC 2 and 3) and had no problems in testing ... I didn't try the upgrade script.<BR>
<BR>
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.<BR>
<BR>
Be interested to hear if the upgrade path works.<BR>
<BR>
Greg W.<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Dylan Beaudette<BR>
Sent: Mon 2/4/2008 4:14 PM<BR>
To: postgis-users@postgis.refractions.net<BR>
Subject: [postgis-users] PSQL 8.3<BR>
<BR>
Anyone tried out PostGIS on the latest release:<BR>
<BR>
<A HREF="http://www.postgresql.org/about/press/presskit83">http://www.postgresql.org/about/press/presskit83</A><BR>
<BR>
??<BR>
<BR>
I am still using 8.1.2- thinking of upgrading, but dreading postgis "hard<BR>
upgrade" path...<BR>
<BR>
Anyone tried this yet?<BR>
<BR>
<BR>
--<BR>
Dylan Beaudette<BR>
Soil Resource Laboratory<BR>
<A HREF="http://casoilresource.lawr.ucdavis.edu/">http://casoilresource.lawr.ucdavis.edu/</A><BR>
University of California at Davis<BR>
530.754.7341<BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>