Andrew Sullivan wrote:
> On Thu, Jun 05, 2008 at 01:43:44PM -0400, Geoffrey wrote:
>> I think I get the gist of this command, but I'm wondering if I'm missing 
>> something.  If I add a trigger to a slave after slony has been set up, 
>> but before any of the nodes have been subscribed, does slony still stop 
>> that trigger from firing?
> 
> No, subscribe the nodes first.  You don't want your trigger firing on every
> row that the subscription copies over!

Good point.  Question though, do I still need the STORE TRIGGER command 
in this situation?  That is, if I add new triggers to the slave database 
after I've started replicating, does slony stop those triggers from firing?

> For a complicated setup like this, you _will_ need a testbed, so I strongly
> suggest you build one.

Exactly, I'm working in our test environment now.  Test slave as well as 
test master.

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin