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@xxxxxxx MSN . scrappy@xxxxxxx
Yahoo . yscrappy Skype: hub.org ICQ . 7615664