Andrew Sullivan ajs at crankycanuck.ca
Fri May 30 08:50:41 PDT 2008
On Fri, May 30, 2008 at 11:10:30AM -0400, Geoffrey wrote:

> First, is it possible, and will it cause any problems to add a table to 
> the slave that will not exist in the master.  We won't be replicating 
> data to this table.

That's fine.
 
> Is it possible to add triggers to the slave tables.  These triggers will 
> update the aforementioned table we will add.

You need to review the documentation on STORE TRIGGER.   Also, pay attention
to this area, because it will be different when you upgrade to 2.x.

> Finally, we will need to set the slony triggers to 'fire always' on our 
> master as we have a process in our production environment which turns 
> off all triggers on a regular basis.

You need to fix that process.  If you go around and thump them, things will
break.  There's no setting that allows you to say, "Even if someone turns
you off, fire anyway."

A


More information about the Slony1-general mailing list