On Tue, Apr 03, 2012 at 05:51:58PM +0000, Shaun McCloud wrote: > I'm wondering if its possible to query any of the databases > in my cluster to see when Slony is done replicating changes > to a single node.
It might help to expand on what you mean exactly by "done replicating changes", as replication is an ongoing process, but you could use the replicate_row action of check_postgres.pl: http://bucardo.org/check_postgres/check_postgres.pl.html Since Slony does things in order, you know that if this check works, the node is "caught up" and has finished anything that might have been going on before the check started. It simply flips a value on a replicated table and reports back how long until that value propagates to another slave (or slaves). -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
pgpmRzo487bUn.pgp
Description: PGP signature
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
