Andrew Sullivan ajs
Tue Jan 30 06:35:50 PST 2007
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  | ajs at crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
		--Dennis Ritchie



More information about the Slony1-general mailing list