Vick Khera vivek at khera.org
Wed Apr 14 10:07:39 PDT 2010
On Wed, Apr 14, 2010 at 12:49 PM, rsv <riyav at hotmail.com> wrote:
> I need to add a new trigger and trigger function on the Master Node. I also
> need that trigger on the Slave, should I need to switchover at any point.
> However I don't want to dropnode on the slave or stop slony when I do it. Is
> there a problem adding a trigger to the Slave while it is being replicated
> t

Use the slonik command EXECUTE SCRIPT to add your triggers.  Whenever
you make *any* schema changes that reference any existing table in any
way (such as foreign keys, triggers etc) you want to do this.

Do not do any schema changes that reference any existing tables on
origin or replicas in any other way.


More information about the Slony1-general mailing list