Nuno Fernandes npf-mlists
Fri Sep 16 18:48:00 PDT 2005
Hi,

I'm testing slony and i have the following question. When an update comes to 
PSQL master node, it is still ACID compliant (as it ought to be), right?
What about slave PSQLs? When slon ships the diferences to subscribes does it 
send them in chunks of transactions? Are the slaves consistent at all times?

Imagine master node has an hardware failure and i failover the DB to slave 
node. Does this one have to be checked for key constrains? I'm ok with some 
data not being forwarded to slave node but the data in slave has to be 
consistent. What procedure should be taken to ensure data integrity in the 
slave node (even though it can loose some transactions)?

Thanks
Nuno Fernandes


More information about the Slony1-general mailing list