| From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How are ppl monitoring PostgreSQL ... ? What is being |
| Date: | 2006-06-11 00:24:26 |
| Message-ID: | 20060610211619.K1114@ganymede.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-06-11 00:32:08 | Re: How are ppl monitoring PostgreSQL ... ? What is being |
| Previous Message | Joshua D. Drake | 2006-06-10 22:04:25 | Re: How are ppl monitoring PostgreSQL ... ? What is being |