[postgis-users] migration/upgrade advice

[John Callahan]

Thanks Regina.  The version I'm running was downloaded last August from
http://www.postgis.org/download/windows/experimental.php, which mentions
Jan 7 on that page.   "SELECT PostGIS_Full_Version();" returns

"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"

Where is the best location to get the latest postgis?  checkout via SVN?

I will give the hard upgrade method a try.

- John

***********************************************
John Callahan, Research Scientist
Delaware Geological Survey, University of Delaware
URL: http://www.dgs.udel.edu
*************************************************



On Wed, Jan 25, 2012 at 5:40 PM, Paragon Corporation <lr at pcorp.us> wrote:

> **
>
>
>   >  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.)
>  January 2011 is a bit old or do you mean 2012?
>
>
>  >  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?
> Correct -- I do it alll tthe time.
>
>  >   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?
>
> 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.
>
> I think your safest bet though is to:
>
> 1) Install the newest version of binaries on PostgreSQL 9.1
> 2) Create a new db with the latest PostGIS 2.0 experimental builds
> 3) Use hard upgrade process.
>
> http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade
> (Note: The windows upgrade link for windows specific instructions) (
> http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade )
>
> If we are talking January 2012 -- then
> 1 ) Install new binaries
> 2) Restore your backup -- some things might fail to restore, that's okay
> 3) Rung the postgis_upgrade_20_minor and
> rtpostgis_upgrade_20_minor.sql
>
> in the share/contrib folder of the experimental zip folder.
>
> Note: Some changes that require a dump restore have happened since we
> distributed the last experimental -- but those changes don't effect raster
> functionality
>  and I plan to release a new build soon once I get my make check working
> again.
>
> Hope that helps,
> Regina
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120125/ee5c8d68/attachment.html>