At the moment then.  Am I correct in thinking that those of us on pg 8.3 and slony 1.2 with fairly large databases have the following options to upgrade;

a) dump restore to 8.4 then rereplicate with 2.02
b) use pg_migrator on our origin nodes the rereplicate with 2.02

I was atleast hoping 1.2 would work with 8.4, or better still an upgrade path from 1.2 to 2.0 would surface...


--- On Tue, 14/7/09, Christopher Browne <cbbrowne at ca.afilias.info> wrote:

> From: Christopher Browne <cbbrowne at ca.afilias.info>
> Subject: Re: [Slony1-general] Does Slony version 1.2.x work with postgresql 8.4?
> To: "Kenneth Marshall" <ktm at rice.edu>
> Cc: slony1-general at lists.slony.info
> Date: Tuesday, 14 July, 2009, 6:07 PM
> 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.
> -- 
> (reverse (concatenate 'string "ofni.sailifa.ac" "@"
> "enworbbc"))
> <http://dba2.int.libertyrms.com/>
> Christopher Browne
> (416) 673-4124 (land)
> "Adding more frammishes to the manual commands seems like
> gilding the
> buggy whip."  -- Tom Lane
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>