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 :(

-- 
F4FQM
Kerunix Flan
Laurent Laborde