[postgis-users] migration/upgrade advice

[John Callahan]

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.)

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?

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?


Thanks for any advice you may have.  I haven't had to move a pg database
before.

- John

***********************************************
John Callahan, Research Scientist
Delaware Geological Survey, University of Delaware
URL: http://www.dgs.udel.edu
*************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120124/946b61cf/attachment.html>