<!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><FONT color=#0000ff size=2
face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
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
class=493483022-25012012><FONT color=#0000ff size=2
face=Arial> </FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012>
<DIV dir=ltr align=left><SPAN class=493483022-25012012><FONT color=#0000ff
size=2 face=Arial>January 2011 is a bit old or do you mean 2012?
</FONT></SPAN></DIV> </SPAN></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT><BR></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
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
class=493483022-25012012><FONT color=#0000ff size=2
face=Arial> </FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
face=Arial>Correct -- I do it alll tthe time.</FONT> </SPAN></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=493483022-25012012> </SPAN></FONT></FONT></FONT><BR></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
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
class=493483022-25012012><FONT color=#0000ff size=2
face=Arial> </FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012></SPAN> </DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
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 class=493483022-25012012><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial>I
think your safest bet though is to:</FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial>1)
Install the newest version of binaries on PostgreSQL 9.1</FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial>2)
Create a new db with the latest PostGIS 2.0 experimental
builds</FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial>3)
Use hard upgrade process.</FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial><A
href="http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade">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">http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade</A> )</FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial>If
we are talking January 2012 -- then </FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012></SPAN><SPAN
class=493483022-25012012></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>1<SPAN class=493483022-25012012> ) Install new
binaries </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=493483022-25012012>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=2><SPAN
class=493483022-25012012>3) Rung the postgis_upgrade_20_minor
and </SPAN></FONT></FONT></FONT><BR><FONT face=Arial><FONT
color=#0000ff><FONT size=2>rtpostgis_upgrade_20_minor.sql<SPAN
class=493483022-25012012> </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=493483022-25012012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=493483022-25012012>in the share/contrib folder of the experimental zip
folder.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=493483022-25012012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=493483022-25012012>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=2><SPAN
class=493483022-25012012> 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 size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2 face=Arial>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=493483022-25012012><FONT color=#0000ff size=2
face=Arial>Regina</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>