<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Input on upgrade to GIS database</TITLE>
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=490382116-17112005><FONT face=Arial color=#0000ff
size=2>Onyx,</FONT></SPAN></DIV>
<DIV><SPAN class=490382116-17112005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=490382116-17112005><FONT face=Arial color=#0000ff size=2>I have
recently preformed a simmilar task. In the name of experimentation I had tried a
coupla methods to move data from an older PostgreSQL(<FONT size=2>8.0.2)</FONT>
+ PostGIS install to a new one (postgresql 8.1 and postgis 1.0.4). The
older database dumped data into a sql loader file. This was then loaded into the
new database via 'psql -f datafile.sql'. This method seems to have
worked although I did notice a couple of errors fly by as the data
loaded. . . Note that the new database is still in the testing phase and
errors could exist that I havent noticed yet.. however so far so
good.</FONT></SPAN></DIV>
<DIV><SPAN class=490382116-17112005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=490382116-17112005><FONT face=Arial color=#0000ff
size=2>Jeremy</FONT></SPAN></DIV>
<DIV><SPAN class=490382116-17112005></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>On Behalf Of
</B>Onyx<BR><B>Sent:</B> November 17, 2005 11:01 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Input
on upgrade to GIS database<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>PostGIS Friends,</FONT> <BR><FONT face=Arial
size=2>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 face=Arial size=2>- PostgreSQL 7.4.6
--> 8.1.0</FONT> <BR><FONT face=Arial size=2>- Geos 2.1.0
--> 2.1.4</FONT> <BR><FONT
face=Arial size=2>- PostGIS 0.9.0
--> 1.0.4</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>Any help would be greatly appreciated.
Thanks!</FONT> </P><BR>
<P><FONT face=Arial size=2>- Onyx</FONT> <BR><FONT face=Arial
size=2>---</FONT> <BR><FONT face=Arial size=2>Onyx Mueller</FONT> <BR><FONT
face=Arial size=2>Software Engineer</FONT> <BR><FONT face=Arial size=2>i-cubed
: information integration & imaging LLC</FONT> <BR><FONT face=Arial
size=2>201 Linden Street : Third Floor</FONT> <BR><FONT face=Arial size=2>Fort
Collins, CO 80524</FONT> <BR><FONT face=Arial size=2>970-482-4400
voice</FONT> <BR><FONT face=Arial size=2>970-482-4499 fax</FONT> <BR><A
href="http://www.i3.com"><U><FONT face=Arial color=#0000ff
size=2>http://</FONT><FONT face=Arial color=#0000ff
size=2>www.i3.com</FONT></U></A> <BR><FONT face=Arial size=2> </FONT>
</P></BLOCKQUOTE></BODY></HTML>