--- On Fri, 17/7/09, Laurent Laborde <kerdezixe at gmail.com> wrote:

> From: Laurent Laborde <kerdezixe at gmail.com>
> Subject: Re: [Slony1-general] Does Slony version 1.2.x work with postgresql  8.4?
> To: slony1-general at lists.slony.info
> Date: Friday, 17 July, 2009, 2:32 PM
> On Tue, Jul 14, 2009 at 7:07 PM,
> Christopher
> Browne<cbbrowne at ca.afilias.info>
> wrote:
> > Kenneth Marshall <ktm at rice.edu>
> writes:
> >> In particular, I would like to be able to upgrade
> an
> >> 8.3 databae to 8.4 with minimal downtime. 1.2.14
> does
> >> not build with a missing function definition for
> >> SerializableSnapshot. If not, is there a scheme
> to
> >> upgrade to 8.4 that does not entail the outage of
> >> a full dump/restore cycle?
> >
> > No, 1.2 does not work with 8.4, and barring having
> considerably more
> > time to play with, it doesn't seem like a
> straightforward backport.
> >
> > There were substantial changes in 8.4 to the
> implementation of
> > pg_listener, to change from on-table storage to an
> in-memory handling
> > that would fairly much break the whole listener loop.
> >
> > Version 2.0 revised that substantially; that doesn't
> seem like a
> > backport, though.
> 
> This is really a major problem.
> upgrade to slony-1 2.x require to rebuild the whole
> cluster.
> upgrade to pgsql-8.4 require to rebuild the whole
> database.
> 
> I cannot find a way to upgrade to 8.4 without innaceptable
> downtime
> unless we upgrade both psql and slony at once :(
> 

We're all in the same boat here, hopefully the ingenious chaps at afilias will pull something out of the bag at some point.