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 > [email protected] > http://gborg.postgresql.org/mailman/listinfo/slony1-general > > -- Jeff Frost, Owner <[EMAIL PROTECTED]> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
