diff options
author | Marcel Haerry <haerry@puzzle.ch> | 2008-04-22 11:43:26 +0200 |
---|---|---|
committer | Marcel Haerry <haerry@puzzle.ch> | 2008-04-22 11:43:26 +0200 |
commit | 09790b4f100dc0268a65e99a84dc19100594fa75 (patch) | |
tree | 7f846dff622e0feaca87e5c23e615ce0df12f3ed /files/plugins/pg_conn | |
parent | b7d5281fa67ff330c28571c9b8df602acba65437 (diff) | |
parent | ebe1a5fdc83e550529fb11f6dd136bda38a0c689 (diff) |
merged immerda
Diffstat (limited to 'files/plugins/pg_conn')
-rwxr-xr-x | files/plugins/pg_conn | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/files/plugins/pg_conn b/files/plugins/pg_conn new file mode 100755 index 0000000..aa2ebb7 --- /dev/null +++ b/files/plugins/pg_conn @@ -0,0 +1,51 @@ +#!/bin/sh +# +# Plugin to monitor PostgreSQL connections. +# +# Parameters: +# +# config (required) +# autoconf (optional - only used by munin-config) +# Based on netstat plugin +# $Log$ +# eric@ohmforce.com +# +# +# Magic markers (optional - used by munin-config and some installation +# scripts): +#%# family=auto +#%# capabilities=autoconf + + + +if [ "$1" = "autoconf" ]; then + if ( netstat -s 2>/dev/null >/dev/null ); then + echo yes + exit 0 + else + if [ $? -eq 127 ] + then + echo "no (netstat program not found)" + exit 1 + else + echo no + exit 1 + fi + fi +fi + +if [ "$1" = "config" ]; then + + echo 'graph_title PostgreSQL' + echo 'graph_args -l 0 ' + echo 'graph_vlabel Number of PostgreSQL connections' + echo 'graph_category postgresql' + echo 'graph_period second' + echo 'graph_info This graph shows the number of opened connections on 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 +netstat -a | awk '{ print $4 }'| grep postgres | wc -l | xargs echo established.value |