David Kerr dmk at mr-paradox.net
Fri Jul 17 08:17:13 PDT 2009
On Thu, Jul 16, 2009 at 09:22:39PM -0700, Gordon Shannon wrote:
- Let's say you have 2 tables, T1 and T2 that you are syncing from the origin
- NodeA to the receiver NodeB, as part of a replication set.  You can't write
- to T2 on NodeB during your maintenance, or ever, because Slony will have
- triggers on the table to prevent writes outside of Slony itself.  Otherwise,
- how could Slony guarantee that the tables are in sync?

Ok that's the key. I was hoping that even though the table was in the 
replication set, I'd be able to write to it on node 2, while still 
replicating other tables from NodeA (but specificially not the one i'm writing 
to on node 2).

I agree, seems like i could cobble something together by dropping and re-creating
/re-syncing sets. But it's probably not worth it.

Thanks

Dave


More information about the Slony1-general mailing list