<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>Input on upgrade to GIS database</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">PostGIS Friends,</FONT>
<BR><FONT SIZE=2 FACE="Arial">I need some help/input on the proper approach to upgrading on GIS-driven database backend, and I am hoping that some of you have been in similar situations. We run a PostgreSQL database with Proj, Geos, and (of course) PostGIS libraries. I want to upgrade the following:</FONT></P>
<P><FONT SIZE=2 FACE="Arial">- PostgreSQL 7.4.6 --> 8.1.0</FONT>
<BR><FONT SIZE=2 FACE="Arial">- Geos 2.1.0 --> 2.1.4</FONT>
<BR><FONT SIZE=2 FACE="Arial">- PostGIS 0.9.0 --> 1.0.4</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">What is the proper approach to get this done successfully, keeping our existing data intact? I know that it is not as simple as 1) dumping the schema & data from the database to a file, 2) moving/deleting PostgreSQL 7.4.6 (and old libraries), 3) installing PostgreSQL 8.1.0 (and the new libraries), and 4) feeding the schema & data back in, although I wish it were that easy. I have read the section of the PostGIS manual on upgrading, but I am worried that there are some other aspects I need to know since I have other variables I am upgrading as well (PostgreSQL & Geos). Has anyone been in my boat before?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Any help would be greatly appreciated. Thanks!</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">- Onyx</FONT>
<BR><FONT SIZE=2 FACE="Arial">---</FONT>
<BR><FONT SIZE=2 FACE="Arial">Onyx Mueller</FONT>
<BR><FONT SIZE=2 FACE="Arial">Software Engineer</FONT>
<BR><FONT SIZE=2 FACE="Arial">i-cubed : information integration & imaging LLC</FONT>
<BR><FONT SIZE=2 FACE="Arial">201 Linden Street : Third Floor</FONT>
<BR><FONT SIZE=2 FACE="Arial">Fort Collins, CO 80524</FONT>
<BR><FONT SIZE=2 FACE="Arial">970-482-4400 voice</FONT>
<BR><FONT SIZE=2 FACE="Arial">970-482-4499 fax</FONT>
<BR><A HREF="http://www.i3.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://</FONT><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.i3.com</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial"> </FONT>
</P>
</BODY>
</HTML>