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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20120404/c8acbfe4/attachment.pgp