Re: nagios -- number of postgres connections

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 %MEM VSZ RSS TTY STAT START TIME COMMAND
postgres 2878 0.0 0.1 152036 1500 ? S Apr05 22:48
/usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 3941 0.0 0.0 13056 460 ? Ss Apr05 0:11
postgres: logger process
postgres 3944 0.0 8.4 152192 87196 ? Ss Apr05 1:35
postgres: writer process
postgres 3945 0.0 0.0 152192 684 ? Ss Apr05 0:10
postgres: wal writer process
postgres 3946 0.0 0.1 152980 1380 ? Ss Apr05 29:13
postgres: autovacuum launcher process
postgres 3947 0.1 0.0 13916 1020 ? Ss Apr05 118:23
postgres: stats collector process

so there's one connection there, and the others are the fixed processes.