Re: [GENERAL] nagios -- number of postgres connections

2009-06-17 Thread Rafael Martinez 
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]
 user postgres
---

-
#!/bin/sh
#
# Plugin to monitor PostgreSQL connections.
#
# Parameters:
#
#   config   (required)
#   autoconf (optional - only used by munin-config)
#
# Magic markers (optional - used by munin-config and some installation
# scripts):
#%# family=auto
#%# capabilities=autoconf

PID_FILE=/var/lib/pgsql/data/postmaster.pid

if [ $1 = autoconf ]; then
  if [  -f $PID_FILE ]; then
echo yes
exit 0
  else
echo no (Service not running)
exit 1
  fi
else
  if [ $1 = suggest ]; then
ls -1 /tmp/
exit 0
  fi
fi


if [ $1 = config ]; then

echo graph_title Number of connections to the database
echo 'graph_args -l 0 '
echo 'graph_vlabel Number of PostgreSQL connections'
echo 'graph_category PostgreSQL'
echo 'graph_period second'
echo 'graph_info The number of opened connections to PostgreSQL.'
echo 'established.label established'
echo 'established.type GAUGE'
echo 'established.max 500'
echo 'established.info The number of currently open connections.'
exit 0
fi

printf 'established.value '
/usr/bin/psql template1 -At -c SELECT count(*) FROM pg_stat_activity
-

PS.- You have to update the PATHS with the values in your system, and
the  user postgres needs access to your database, for this plugin to work.

regards,
-- 
 Rafael Martinez, r.m.guerr...@usit.uio.no
 Center for Information Technology Services
 University of Oslo, Norway

 PGP Public Key: http://folk.uio.no/rafael/

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] nagios -- number of postgres connections

2009-06-17 Thread Rafael Martinez 
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 with:
 

And of course this is for munin and not nagios. Sorry.

-- 
 Rafael Martinez, r.m.guerr...@usit.uio.no
 Center for Information Technology Services
 University of Oslo, Norway

 PGP Public Key: http://folk.uio.no/rafael/

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] nagios -- number of postgres connections

2009-06-16 Thread Whit Armstrong 
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

Re: [GENERAL] nagios -- number of postgres connections

2009-06-16 Thread John R Pierce 

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 COMMAND
postgres  2878  0.0  0.1 152036  1500 ?SApr05  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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] nagios -- number of postgres connections

2009-06-16 Thread Scott Mead 
On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce pie...@hogranch.com 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

Re: [GENERAL] nagios -- number of postgres connections

2009-06-16 Thread Jeff Frost 
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/check_postgres.pl.html#backends


-- 
Jeff Frost, Owner   j...@frostconsultingllc.com
Frost Consulting, LLC   http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] nagios -- number of postgres connections

2009-06-16 Thread Scott Mead 
On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce pie...@hogranch.com 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