Hi All, below is my assumption regarding failover, so please correct me if I'm wrong -
------------------------------------------------------------------------------- a table T is created with primary key K (sequence), Slony is configured to replicate both table T and primary key K. When a failover is made, there could be a short instance where new row(s) are inserted and replicated to the slave, but the sequence's last value is still not updated at the slave. As such, subsequent inserts would fail with duplicate key error until the slave's value is adjusted, manually or otherwise. ------------------------------------------------------------------------------- If the above situation should occur, what can done to prevent/eliminate/avoid it? Regards Andrew -- Andrew Ng [EMAIL PROTECTED] -- http://www.fastmail.fm - A fast, anti-spam email service. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
