On Wed, Oct 01, 2008 at 01:08:21PM -0500, Jeff Amiel wrote: > Let's assume my origin is 'gone' (destroyed in a nuclear burst)....I > have no way to 'dump' the subscriber node?
You do after you perform FAILOVER, because it becomes the origin. But. . . > In my case I 'may' have hand-added triggers to the subscriber node (as > well as origin) at one point without using slonik execute_script..... You 'may' have a problem, then. If you want the trigger to be on all nodes, and disabled on the replicas, then you need to add it via EXECUTE SCRIPT. If you want it just on one or more replicas, that is the purpose of STORE TRIGGER. I think you need to drop these triggers and create them the right way. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
