Geoffrey lists at serioustechnology.com
Fri May 30 08:10:30 PDT 2008
We are about to revisit replication via slony since we now have upgraded 
our databases to 8.3.1.  There are a couple of issues I need to address 
though.

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.

Is it possible to add triggers to the slave tables.  These triggers will 
update the aforementioned table we will add.

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.

-- 
Until later, Geoffrey

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


More information about the Slony1-general mailing list