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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
