I use a simple perl script with few external dependencies to check my node lag hourly:
http://www.altosresearch.com/customer/slony-lag-check.pl It does use a strange Gmail specific email library to send the alert, but you can swap out any alert mechanism you like. -jason On Tue, Oct 6, 2009 at 3:27 AM, Lawrence Giam < [email protected]> wrote: > Hi All, > > I have been looking at how to implement monitoring for Slony and would like > to have some recommendations on debian. Looking at the tools provided, when > I tried to use the psql_replication_check.pl and > test_slony_state_replication.pl, it always report a problem with "Can't > locate Pg.pm". Is there a missing library file that I have to install? How > can I port the 2 script over to using the DBI interface? > > Also can someone explain more on what are the things to monitor in Slony? I > am looking at using iPmonitor SQL QA engine with PostgreSQL OLEDB plugin to > monitor the replication but do not know what exactly to look for. Or perhap > using a bash script to grep some info and send report etc... > > > *Regards,* > > *Lawrence Giam > > * > > <http://www.globalitcreations.com/> > > .................................................................................................. > Lawrence Giam | Global IT Creations Pte Ltd | Network Administrator > website: http://www.globalitcreations.com > phone: +65 6836 4768 ext 115| fax: + 65 6836 4736 | mobile: + 65 9758 > 7448 > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > > -- Jason L. Buberel [email protected]
<<gitclogo.jpg>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
