<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16440"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=481255013-26012012><FONT color=#0000ff
size=2 face=Arial>Oops. My bad. I had a typo on the page. I'll
fix. That should have read January 7, 2012.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=481255013-26012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=481255013-26012012><FONT color=#0000ff
size=2 face=Arial>If you are using that one, then you should be good to go since
I haven't released a new version yet. Just use the 9.1 binaries on
that page and restore your backup and you should be good to
go.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>John Callahan<BR><B>Sent:</B> Wednesday, January 25, 2012 11:50
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re:
[postgis-users] migration/upgrade advice<BR></FONT><BR></DIV>
<DIV></DIV>Thanks Regina. The version I'm running was downloaded last
August from <A
href="http://www.postgis.org/download/windows/experimental.php">http://www.postgis.org/download/windows/experimental.php</A>,
which mentions Jan 7 on that page. "SELECT PostGIS_Full_Version();"
returns
<DIV><BR></DIV>
<DIV>
<DIV>"POSTGIS="2.0.0SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.6.1, 21 August
2008" LIBXML="2.7.6" USE_STATS"</DIV></DIV>
<DIV><BR></DIV>
<DIV>Where is the best location to get the latest postgis? checkout via
SVN?</DIV>
<DIV><BR></DIV>
<DIV>I will give the hard upgrade method a try. </DIV>
<DIV><BR></DIV>
<DIV>
<DIV>- John</DIV>
<DIV><BR></DIV>***********************************************<BR>John
Callahan, Research Scientist<BR>Delaware Geological Survey, University of
Delaware<BR>URL: <A href="http://www.dgs.udel.edu"
target=_blank>http://www.dgs.udel.edu</A><BR>*************************************************<BR><BR><BR><BR>
<DIV class=gmail_quote>On Wed, Jan 25, 2012 at 5:40 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote><U></U>
<DIV>
<DIV dir=ltr align=left><FONT color=#0000ff face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV class=im>
<DIV></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial> > </FONT></SPAN>I
unfortunately have to move my Postgres/PostGIS database to a new Windows
server. My current (source) db is Postgres 9.0.2 with PostGIS
2.0.0SVN (I believe from Jan 2011.)<SPAN><FONT color=#0000ff
face=Arial> </FONT></SPAN></DIV></DIV>
<DIV><SPAN>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff face=Arial>January 2011
is a bit old or do you mean 2012? </FONT></SPAN></DIV> </SPAN></DIV>
<DIV class=im>
<DIV><FONT color=#0000ff face=Arial></FONT><BR></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial> >
</FONT></SPAN>The new (destination) db will likely be Postgres
9.1.2. It seems like I can use pg_dump to go from 9.0.2 to 9.1.2, as
long as I use the 9.1 version of pg_dump. Is that true?<SPAN><FONT
color=#0000ff face=Arial> </FONT></SPAN></DIV></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>Correct -- I do it alll
tthe time.</FONT> </SPAN></DIV>
<DIV class=im>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=+0><SPAN></SPAN></FONT></FONT></FONT><BR> </DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial> >
</FONT></SPAN>For PostGIS 2.0, I plan to install the same version on
both the source and destination db. I'll do this before importing
from pg_dump. I can then update PostGIS on the new db after the
migration is complete. Does that make sense? or should I
install a newer version of PostGIS immediately? <SPAN><FONT
color=#0000ff face=Arial> </FONT></SPAN></DIV>
<DIV><SPAN></SPAN> </DIV></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>Depends how old your version is
-- if its really 2011, I'm not sure our upgrade script can handle that far
back cleanly. You can try.</FONT> </SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>I think your safest bet though
is to:</FONT></SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>1) Install the newest version of
binaries on PostgreSQL 9.1</FONT></SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>2) Create a new db with the
latest PostGIS 2.0 experimental builds</FONT></SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>3) Use hard upgrade
process.</FONT></SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial><A
href="http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade"
target=_blank>http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade</A>
(Note: The windows upgrade link for windows specific instructions) ( <A
href="http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade"
target=_blank>http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade</A> )</FONT></SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>If we are talking January 2012
-- then </FONT></SPAN></DIV>
<DIV><SPAN></SPAN><SPAN></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=+0>1<SPAN> ) Install new
binaries </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=+0><SPAN>2) Restore
your backup -- some things might fail to restore, that's
okay</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=+0><SPAN>3) Rung the
postgis_upgrade_20_minor
and </SPAN></FONT></FONT></FONT><BR><FONT face=Arial><FONT
color=#0000ff><FONT
size=+0>rtpostgis_upgrade_20_minor.sql<SPAN> </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=+0><SPAN></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=+0><SPAN>in the
share/contrib folder of the experimental zip
folder.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=+0><SPAN></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=+0><SPAN>Note: Some
changes that require a dump restore have happened since we distributed the
last experimental -- but those changes don't effect raster
functionality</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=+0><SPAN> and I
plan to release a new build soon once I get my make check working
again.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial></FONT> </DIV>
<DIV><SPAN><FONT color=#0000ff face=Arial>Hope that
helps,</FONT></SPAN></DIV>
<DIV><SPAN><FONT color=#0000ff
face=Arial>Regina</FONT></SPAN></DIV></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BLOCKQUOTE></BODY></HTML>