Re: How are ppl monitoring PostgreSQL ... ? What is being

On Sat, Jun 10, 2006 at 07:29:52PM +0100, Andy Shellam wrote:
> I'm using a great little Linux program called "monit" to check that
> there's something listening on the 5432 port.  It also monitors
> individual process memory and CPU usage etc.  Quite good.

A server can be quite broken yet still respond to transport- and
network-layer probes like TCP connections and pings.  Some NMSs
support custom monitors, so whenever possible I like to do
application-layer tests to ensure that the server not only accepts
connections but is indeed behaving as expected.

> Marc G. Fournier wrote:
> >
> > The subject kinda says it all ... I know there are SNMP patches
> > available out there now, but without those ... ?

MRTG can generate graphs of anything you can write a script to
measure, as long as the script returns output in a certain format.
Other packages of that ilk probably have similar capabilities.

--
Michael Fuhr