[postgis-users] Question Upgrading to PostgreSQL8.2 PG1.2.1

[Randy George]

Thanks Mark,

	Barend's cross platform difficulty is more complex than mine. My
dump restore does appear to work. It just lists a lot of warnings and will
take several days. Fortunately the data sets are largely read only with
extra drive space. 

	The soft upgrade from 8.1/1.1.1 to 8.1/1.2.1 worked without a
problem on two Windows 2003 servers.

Here is an interesting thread on In-place upgrades:
http://archives.postgresql.org/pgsql-hackers/2006-08/msg00327.php
 

Thanks
Randy



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Thursday, March 08, 2007 1:58 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Question Upgrading to PostgreSQL8.2 PG1.2.1

On Wed, 2007-03-07 at 15:39 -0700, Randy George wrote:
> Hi,
> 
>  
> 
> I thought that PostgreSQL 8.1 to 8.2 required a dump/restore? 
> 
> http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
> 
> http://www.postgresql.org/docs/8.2/interactive/migration.html
> 
>  
> 
> Maybe I should live with 8.1 and try a soft upgrade on PG1.2.1, but
> sooner or later I'll have to make the move.
> 
>  
> 
> thanks
> 
> randy


Hi Randy,

You may find the advice in this thread useful:
http://postgis.refractions.net/pipermail/postgis-users/2007-January/014508.h
tml.


Kind regards,

Mark.


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users