Attached is my perl script to do this.

It's pretty basic so I doubt you lot would find it useful, but seeing
as it really is a "my first perl script" any criticism would be
welcome and appreciated.

Glyn

--- JP Fletcher <jpfletch at ca.afilias.info> wrote:

> Glyn Astill wrote:
> > Hi chaps,
> > 
> > I've been looking at the available plugins for nagios to check
> the
> > state of Slony replication.
> > 
> > I see theres a couple of perl scripts, that try and track an
> update
> > across the nodes, then theres is a psql_replication_check.pl
> script
> > that checks the timestamp on a recent update.
> > 
> > Am I not mistaken in thinking that the best thing to monitor
> would be
> > the sl_status view on each node? 
> 
> I think you would want to monitor st_lag_num_events on the origin
> for
> each set, not on the downstream nodes.
> 
> 
> Then if st_lag_num_events goes
> > above a certain limit we know there may be a problem?
> > 
> > Of course this would not help us on a table by table basis, but
> it's
> > surely a good idea to be monitoring it is it not?
> > 
> > And if so are is anyone aware of plugins that already exist
> before I
> > attempt to create one?
> > 
> > Glyn
> > 
> > 
> >       ___________________________________________________________
> > Support the World Aids Awareness campaign this month with Yahoo!
> For Good http://uk.promotions.yahoo.com/forgood/
> > 
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at lists.slony.info
> > http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 
> -- 
> JP Fletcher
> Database Administrator
> Afilias Canada
> voice: 416.646.3304 ext. 4123
> fax: 416.646.3305
> mobile: 416.561.4763
> jpfletch at ca.afilias.info
> 



      ___________________________________________________________
Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_slony.pl
Type: application/octet-stream
Size: 3128 bytes
Desc: 2456555266-check_slony.pl
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20080130/0f8976a1/check_slony.obj