On Tue, Jul 14, 2009 at 01:07:49PM -0400, Christopher Browne 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.
> -- 
> (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
> 
Thank you Chris. I will build 8.4 with Slony1 2.0.2.

Regards,
Ken