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