plugin-pg_diskusage: pg_diskusage

#!/bin/sh
#
# Script to monitor disk usage of PostgreSQL databases.
# Requires oid2name, usually bundled in some "contrib" package.
# Most likely requires to be run as postgresql user or root.
#
# Tested with PostgreSQL 8.0, 8.1
#
# Parameters understood:
#
#       config   (required)
#       autoconf (optional - used by munin-config)
#
#
# Magic markers (optional - used by munin-config and installation
# scripts):
#
#%# family=auto
#%# capabilities=autoconf

OID2NAME=/usr/bin/oid2name
ARGS='-U postgres -q'
PGDATA=/var/lib/pgsql/data/base/

if [ "$1" = "autoconf" ]; then
    if ( $OID2NAME $ARGS -s 2>/dev/null >/dev/null ); then
        echo yes
        exit 0
    else
        if [ $? -eq 127 ]
            then
            echo "no (oid2name program not found)"
            exit 1
        else
            echo no
            exit 1
        fi
    fi
fi

cd ${PGDATA}

if [ "$1" = "config" ]; then

    echo 'graph_title PostgreSQL filesystem usage'
    echo 'graph_args -l 0'
    echo 'graph_vlabel bytes'
    echo 'graph_category PostgreSQL'
    echo 'graph_info This graph shows disk usage of each PostgreSQL database.'
    $OID2NAME $ARGS | while read OID DBNAME OPT; do
        echo "$DBNAME.label $DBNAME"
        echo "$DBNAME.info OID $OID"
        echo "$DBNAME.warning 5000000000"
        echo "$DBNAME.critical 10000000000"
    done
fi

$OID2NAME $ARGS | while read OID DBNAME OPT; do
    echo -n "$DBNAME.value "
    echo `du -bs $OID` | awk '{ print $1 }'
done