pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcheckcommands.conf templates for check_postgres.pl
2+ messages / 2 participants
[nested] [flat]
* checkcommands.conf templates for check_postgres.pl
@ 2008-04-07 15:53 Brian A. Seklecki <lavalamp@spiritual-machines.org>
0 siblings, 1 reply; 2+ messages in thread
From: Brian A. Seklecki @ 2008-04-07 15:53 UTC (permalink / raw)
To: Nagios Discussion <nagios-users@lists.sourceforge.net>; pgsql-admin; +Cc: greg@turnstep.com
[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
}
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: checkcommands.conf templates for check_postgres.pl
@ 2008-04-18 01:13 Greg Sabino Mullane <greg@turnstep.com>
parent: Brian A. Seklecki <lavalamp@spiritual-machines.org>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Sabino Mullane @ 2008-04-18 01:13 UTC (permalink / raw)
To: lavalamp@spiritual-machines.org; +Cc: pgsql-admin; nagios-users@lists.sourceforge.net
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> It probably wouldn't be a bad idea to include some checkcommands.conf
> templates and example service or hostgroup examples. See below.
Thank you, just committed and pushed. Will be in version 1.5.1, or in
1.6.0 if we get there first. You can grab the latest version with these
changes via git; suggestions are always welcome:
git-clone http://bucardo.org/check_postgres.git/
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200804172108
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkgH9YgACgkQvJuQZxSWSsgUkgCfbJLVrhRxt/bD4PiLek8MN0MR
hWwAniP3QCG1CFrIfWhz+qx/mWpoTwLq
=qyRD
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-18 01:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-07 15:53 checkcommands.conf templates for check_postgres.pl Brian A. Seklecki <lavalamp@spiritual-machines.org>
2008-04-18 01:13 ` Greg Sabino Mullane <greg@turnstep.com>
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