Frank McGeough Frank.Mcgeough at vocalocity.com
Tue Apr 26 07:41:18 PDT 2011
I'm using Postgres 8.4 and Slony 1.2.20. 

My database replication configuration is a master with two slaves. 

I have a table "A" that is replicated. A trigger existed on table "A" that called a function that inserted into another table "B" that was replicated. 

I don't need to replicate table "B" anymore. I've removed it from the replication set. 

I'd like to clean up the trigger and function as well but, although I can easily drop these on the master, the slave trigger is hidden by slony. 

What is the approach used to drop unneeded triggers from slaves? 

Thanks,
Frank


More information about the Slony1-general mailing list