Fri May 30 08:50:41 PDT 2008
- Previous message: [Slony1-general] adding tables/triggers to a slony slave
- Next message: [Slony1-general] adding tables/triggers to a slony slave
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] adding tables/triggers to a slony slave
- Next message: [Slony1-general] adding tables/triggers to a slony slave
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list