Well crap.  Yahoo ate my attachment.  The file is now
posted at http://unwg.no-ip.com/check_slony.pl.txt

Here is my original email:

We wrote a Nagios plugin in perl.  Basically, it
checks the "event" table on all nodes to see if each
node has had a SYNC within the past 10 seconds.  No
fussing with PIDs and processes.  Besides, a PID can
always be recycled by a different process, so if you
check to see if a process with that PID exists, it
might not the the same slony process that you wanted
to check on.

I'm not sure if attachments to this mailing list are
acceptable.  If they are not, then kindly tell me and
I'll never do it again.

The attached file is the perl script that we use
inside Nagios (network monitoring software).  I coded
it from a skeleton script that did something
completely different for Nagios.  The code can be used
by anyone, no strings attached (just don't sue me if
it breaks your systems).

If someone wants to tidy it up and add it to some
"contrib" of either slony or nagios that would be
cool.  Too much ambition for me.

--- Jim Archer <jim at archer.net> wrote:

> Hi All...
> 
> I was wondering if anyone had any code that monitors
> a slon and, if it 
> stops, restarts it?  If so, would you be willing to
> share?  I have servers 
> in other places and, very occasionally, connectivity
> is briefly lost, which 
> kills the slon.
> 
> Thanks very much...
> 
> Jim
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
>
http://gborg.postgresql.org/mailman/listinfo/slony1-general
> 


Dennis Jenkins