Re: upgrade to 8.2.? or implement Slony, which first? - Mailing list pgsql-general

From Joseph S
Subject Re: upgrade to 8.2.? or implement Slony, which first?
Date
Msg-id f88smt$1dsu$1@news.hub.org
Whole thread Raw
In response to upgrade to 8.2.? or implement Slony, which first?  (Geoffrey <lists@serioustechnology.com>)
Responses Re: upgrade to 8.2.? or implement Slony, which first?  (Geoffrey <lists@serioustechnology.com>)
Re: upgrade to 8.2.? or implement Slony, which first?  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
If you don't mind the downtime it would be simpler to upgrade to 8.2 and
then worry about Slony.  If you do mind you can use slony to do the
upgrade which needs much less downtime as you switch servers.

Geoffrey wrote:
> We plan to upgrade from our current 7.4.17 Postgresql to 8.2.? in the
> near future.  We also plan to implement a replication solution, most
> likely Slony.
>
> We know that the upgrade to 8.2.? will require some code changes.
>
> Question is, is there a particular order in which we should perform
> these changes that would require the least amount of additional work?
>
> That is, would it be more efficient to move to 8.2.? and then implement
> our Slony replication, or would there be less effort in implementing the
> Slony solution and then upgrading to 8.2.? ?
>

pgsql-general by date:

Previous
From: Joseph S
Date:
Subject: inherting triggers
Next
From: "Gavin M. Roy"
Date:
Subject: Re: Import excel to postgres based website?