pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brian A. Seklecki <lavalamp@spiritual-machines.org>
To: Nagios Discussion <nagios-users@lists.sourceforge.net>
To: pgsql-admin@postgresql.org
Cc: greg@turnstep.com
Subject: checkcommands.conf templates for check_postgres.pl
Date: Mon, 07 Apr 2008 11:53:57 -0400
Message-ID: <1207583637.12507.53.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com> (raw)


[may be more nagiosplug-devel@ related, but hey!]


It probably wouldn't be a bad idea to include some checkcommands.conf
templates and example service or hostgroup examples.  See below.



---- Templates ----


define command {
        command_name    check_postgres_size
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action database_size -w $ARG1$ -c $ARG2$
}

define command {
        command_name    check_postgres_time
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action timesync -w $ARG1$ -c $ARG2$
}

define command {
        command_name    check_postgres_backends
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action backends -w $ARG1$ -c $ARG2$
}

define command {
        command_name    check_postgres_last_vacuum
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action last_vacuum -w $ARG1$ -c $ARG2$
}

define command {
        command_name    check_postgres_bloat
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action bloat -w $ARG1$ -c $ARG2$
}

define command {
        command_name    check_postgres_settings_checksum
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action settings_checksum -c $ARG1$
}


define command {
        command_name    check_postgres_locks
        command_line    $USER2$/check_postgres.pl -H $HOSTADDRESS$ -u
pgsql -db postgres --action locks -w $ARG1$ -c $ARG2$
}





---- Service Check Examples ----






[Host Definition]


define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service
Database Usage Size
        check_command                   check_postgres_size!256000000!
512000000
}

define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service
Database Locks
        check_command                   check_postgres_locks!2!3
}


define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service Last
Vacuum
        check_command                   check_postgres_last_vacuum!600!
900
}

define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service
Database Configuration Checksum
        check_command
check_postgres_settings_checksum!654104dd9397d7032c275a165c33d6e0
}

define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service
Database Bloat
        check_command                   check_postgres_bloat!3000000!
9000000
}

define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service Active
Backend Threads
        check_command                   check_postgres_backends!40!60
}

define service{
        use                             generic-other
        host_name                       dbhost.gtld
        service_description             dbhost PostgreSQL Service NTP
Jitter
        check_command                   check_postgres_time!1!2
}





view thread (2+ messages)  latest in thread

Message-ID: <1207583637.12507.53.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
Permalink:  ../1207583637.12507.53.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com/
Also on:    postgresql.org/message-id/1207583637.12507.53.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: lavalamp@spiritual-machines.org, nagios-users@lists.sourceforge.net, greg@turnstep.com
  Subject: Re: checkcommands.conf templates for check_postgres.pl
  In-Reply-To: <1207583637.12507.53.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox