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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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><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>1<span> ) Install new
binaries </span></font></font></font></div>
<div><font face="Arial"><font color="#0000ff"><font><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><span>3) Rung the postgis_upgrade_20_minor
and </span></font></font></font><br><font face="Arial"><font color="#0000ff"><font>rtpostgis_upgrade_20_minor.sql<span> </span></font></font></font></div>
<div><font face="Arial"><font color="#0000ff"><font><span></span></font></font></font> </div>
<div><font face="Arial"><font color="#0000ff"><font><span>in the share/contrib folder of the experimental zip
folder.</span></font></font></font></div>
<div><font face="Arial"><font color="#0000ff"><font><span></span></font></font></font> </div>
<div><font face="Arial"><font color="#0000ff"><font><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><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>