[postgis-users] Input on upgrade to GIS database

[Daniel]

You can use dump/restore, but in this case, you'll need to use 
postgis_restore.pl, an utility which come with postgis.

Before proceeding, make solid backups of all your data: pg_dump with 
full inserts. With this files, you'll always be able to retrieve your data.

If you can, configure the new postgresql BEFORE erasing old version. So, 
you'll always be able to backup old data.

Be aware with PostGIS upgrade: the internal format for geometries have 
changed: you may need to modify existing source codes of your applications.

Yours,

dF



Onyx wrote:

> PostGIS Friends,
> I need some help/input on the proper approach to upgrading on 
> GIS-driven database backend, and I am hoping that some of you have 
> been in similar situations.  We run a PostgreSQL database with Proj, 
> Geos, and (of course) PostGIS libraries.  I want to upgrade the following:
>
> - PostgreSQL 7.4.6      --> 8.1.0
> - Geos 2.1.0            --> 2.1.4
> - PostGIS 0.9.0         --> 1.0.4
>
> What is the proper approach to get this done successfully, keeping our 
> existing data intact?  I know that it is not as simple as 1) dumping 
> the schema & data from the database to a file, 2) moving/deleting 
> PostgreSQL 7.4.6 (and old libraries), 3) installing PostgreSQL 8.1.0 
> (and the new libraries), and 4) feeding the schema & data back in, 
> although I wish it were that easy.  I have read the section of the 
> PostGIS manual on upgrading, but I am worried that there are some 
> other aspects I need to know since I have other variables I am 
> upgrading as well (PostgreSQL & Geos).  Has anyone been in my boat before?
>
> Any help would be greatly appreciated.  Thanks!
>
>
> - Onyx
> ---
> Onyx Mueller
> Software Engineer
> i-cubed : information integration & imaging LLC
> 201 Linden Street : Third Floor
> Fort Collins, CO  80524
> 970-482-4400 voice
> 970-482-4499 fax
> _http://www.i3.com_ <http://www.i3.com>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>  
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: daniel.faivre.vcf
Type: text/x-vcard
Size: 323 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20051117/a8867f83/attachment.vcf>