Re: Considering an upgrade... - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Considering an upgrade...
Date
Msg-id 20051013154538.GF16317@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Considering an upgrade...  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On Wed, Oct 12, 2005 at 06:15:36PM -0400, Robert Treat wrote:
>
> IIRC Slony wont run on anything < 7.3.6, so you would have to do an in place
> upgrade to 7.3.x as appropriate, and then you could set up slony to propogate
> to the 8.x system.

You should do that anyway, because on older releases, you really
don't want to lag the last dot-release -- there are usually some big
bugs that have been shaken out.

One thing that is really nice about using the Slony trick, by the
way, is that when you switchover to your upgraded system, you make
your old database into a replica too.  That means that you have the
ability to roll back to the old release if, once you get the new
system into production use, you happen to find something you'd
overlooked.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
        --attr. John Maynard Keynes

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: graphs in PostgreSQL
Next
From: Scott Marlowe
Date:
Subject: Re: Limitations of PostgreSQL