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 . [EMAIL PROTECTED]                              MSN . [EMAIL PROTECTED]
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to