Re: Upgrading Postgres question - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Upgrading Postgres question
Date
Msg-id dcc563d10811101003l19e5eb9fg286f1c8ec9efd72f@mail.gmail.com
Whole thread Raw
In response to Upgrading Postgres question  ("Tony Fernandez" <Tony.Fernandez@vocalocity.com>)
Responses Re: Upgrading Postgres question
List pgsql-general
On Wed, Nov 5, 2008 at 2:19 PM, Tony Fernandez
<Tony.Fernandez@vocalocity.com> wrote:
> Hello all,
>
>
>
> I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4.  I also
> use Slony 1.2.14 for replication.

Then you're set.  One of the primary purposes of slony is upgrading in
place.  Take one of your backup slaves offline, upgrade it to 8.3,
recreate it as a slony slave, and let it run for a few days.  When all
seems well, swap the two servers.  downtime measured in seconds.

pgsql-general by date:

Previous
From: "Asko Oja"
Date:
Subject: Re: Logging in function with exception
Next
From: Greg Smith
Date:
Subject: Current log files when rotating?