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 *************************************************
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
