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
copy link · copy postgr.es
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