I just update a timestamp in a slony_test table every 5 minutes on the master 
and check that on the slaves to make sure it's not more than x minutes old. 
The scripts are simple shell that calls psql.

On Tue, 23 Jan 2007, Mark Stosberg wrote:

> Hello,
>
> I'm wondering what people are using to monitor Slony with Nagios. The
> docs reference:
>
> psql_replication_check.pl
>
> ... but that uses the very ancient "Pg.pm" and not DBI/DBD::Pg.
>
> I also see "test_slony_state-dbi.pl", which uses DBI, but is not
> referenced as a Nagios plugin.
>
> I'm also curious if anyone is using Nagios' event handling as part of
> failover-- using it to notice that a slave is down, and then make a
> pro-active change to handle failover.
>
> I'm evaluating various options to handle failover. DBIx::HA seems like
> area reasonable solution for Perl, but I'm still exploring other options
> at this point.
>
>  Mark
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
>

-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954