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

["Marc G. Fournier" <scrappy(at)postgresql(dot)org>]

On Sat, 10 Jun 2006, Joshua D. Drake wrote:

> Marc G. Fournier wrote:
> > The subject kinda says it all ... I know there are SNMP patches available 
> > out there now, but without those ... ?
>
> We use Nagios to call shell scripts that perform specific requests to a 
> PostgreSQL server. Usually over SSH via psql, but you could use anything.

'k, so what are you testing for?  Just that a query runs?  time it takes 
to run?  specific results?

SELECT count(1) FROM pg_connections;

would be a good one to graph ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org                              MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664