Going along with my last email, how do you view the current configuration values for Slony (specifically the cleanup_interval) and change the cleanup _interval after the cluster has been created in a Windows environment?
Shaun McCloud – Associate Software Developer Geo-Comm, Inc 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Think before you print! Microsoft Certified Desktop Support Technician (MCDST) -----Original Message----- From: Greg Sabino Mullane [mailto:[email protected]] Sent: Wednesday, April 04, 2012 16:45 To: Shaun McCloud Cc: [email protected] Subject: Re: [Slony1-general] Query to see when Slony is done replicating changes? 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 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
