On Mon, Jan 29, 2007 at 05:37:08PM -0800, Casey Duncan wrote:
> 1. Turn off slon daemons
> 2. Switch application to use the secondary (read-only of course)
> 3. Run the upgrade script on the primary using execute script and add  
> tables & sequences into a new set and merge waiting for subscriptions  
> to be confirmed (which blocks).

This won't work.  You need to have the slon daemons running for a
WAIT FOR EVENT to work.  DDL _just requires_ an outage.  Sorry.

A

-- 
Andrew Sullivan  | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
                --Dennis Ritchie
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to