Rafael Martinez wrote:
> Whit Armstrong wrote:
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>> Thanks,
>> Whit
>>
>
> Hello
>
> We use this plugin. Save it under /etc/munin/plugins/pg_connections and
> update the file /etc/munin/plugin-conf.d/postgres w
Whit Armstrong wrote:
> anyone know a way to get nagios to monitor the number of postgres connections?
>
> Thanks,
> Whit
>
Hello
We use this plugin. Save it under /etc/munin/plugins/pg_connections and
update the file /etc/munin/plugin-conf.d/postgres with:
---
[pg_connection]
On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce wrote:
> Whit Armstrong wrote:
>
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>>
>
You could also login to the database and run:
select count(1) from pg_stat_activity;
--Scott
John R Pierce wrote:
> Whit Armstrong wrote:
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>
Check out the check_postgres nagios plugin:
http://bucardo.org/check_postgres/
Specifically you want the backends check:
http://bucardo.org/check_postgres/chec
On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce wrote:
> Whit Armstrong wrote:
>
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>>
>
You could also login to the database and run:
select count(1) from pg_stat_activity;
--Scott
Whit Armstrong wrote:
anyone know a way to get nagios to monitor the number of postgres connections?
a script that counts how many lines of postgres processes there are and
subtracts a few
$ ps -C postmaster uww
USER PID %CPU %MEMVSZ RSS TTY STAT START TIME COMMAN
anyone know a way to get nagios to monitor the number of postgres connections?
Thanks,
Whit
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
