check_postgres/nagios-commands-postgres.cfg

#
# Command definitions for check_postgres.pl
#
# Notes:
#
# - to enabled these command definitions:
#	- cp nagios-commands-postgres.cfg /etc/nagios/objects/
#	- add cfg_file=/etc/nagios/objects/nagios-commands-postgres.cfg to /etc/nagios/nagios.cfg
#
# OR
#
# - if using check_mk see http://mathias-kettner.de/checkmk_legacy_checks.html
#
#	- cp nagios-commands-postgres.cfg /etc/check_mk/conf.d/extra_nagios_conf.mk
#	- add to beginning of file uncomment:
#		extra_nagios_conf += r"""
#	- add to end of file uncomment:
#		"""
#
# - setting the pguser password in this file is not advised, use a .pgpass file instead when possible
#
#	Example, assuming the same user/pass on all servers)
#
#		echo "*:*:*:pgmonitor:password" > /var/lib/nagios/.pgpass
#		chmod 0600 /var/lib/nagios/.pgpass
#		chown nagios:nagios /var/lib/nagios/.pgpass

# uncomment for check_mk legacy_checks
#extra_nagios_conf += r"""

# 'check_postgres_archive_ready' command definition
#
# This command requires SUPERUSER privileges
define command {
	command_name	check_postgres_archive_ready
	command_line	$USER1$/check_postgres_archive_ready -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_autovac_freeze' command definition
define command {
	command_name	check_postgres_autovac_freeze
	command_line	$USER1$/check_postgres_autovac_freeze -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_backends' command definition
define command {
	command_name	check_postgres_backends
	command_line	$USER1$/check_postgres_backends -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_bloat' command definition
define command {
	command_name	check_postgres_bloat
	command_line	$USER1$/check_postgres_bloat -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_checkpoint' command definition
#
# Can only be run as the user who initialized a database cluster
#define command {
#	command_name	check_postgres_checkpoint
#	command_line	$USER1$/check_postgres_checkpoint -H $HOSTADDRESS$ -u pgmonitor --datadir $ARG1$
#	}

# 'check_postgres_cluster_id' command definition
#
# This is a local check
#define command {
#	command_name	check_postgres_cluster_id
#	command_line	$USER1$/check_postgres_cluster_id -H $HOSTADDRESS$
#	}

# 'check_postgres_connection' command definition
define command {
	command_name	check_postgres_connection
	command_line	$USER1$/check_postgres_connection -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_custom_query' command definition
define command {
	command_name	check_postgres_custom_query
	command_line	$USER1$/check_postgres_custom_query -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_database_size' command definition
define command {
	command_name	check_postgres_database_size
	command_line	$USER1$/check_postgres_database_size -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_disabled_triggers' command definition
define command {
	command_name	check_postgres_disabled_triggers
	command_line	$USER1$/check_postgres_disabled_triggers -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_disk_space' command definition
#
# This command requires SUPERUSER privileges
define command {
	command_name	check_postgres_disk_space
	command_line	$USER1$/check_postgres_disk_space -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_fsm_pages' command definition
#
# Cannot check fsm_pages on servers version 8.4 or greater
define command {
	command_name	check_postgres_fsm_pages
	command_line	$USER1$/check_postgres_fsm_pages -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_fsm_relations' command definition
#
# Cannot check fsm_pages on servers version 8.4 or greater
define command {
	command_name	check_postgres_fsm_relations
	command_line	$USER1$/check_postgres_fsm_relations -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_hitratio' command definition
#
define command {
	command_name	check_postgres_hitratio
	command_line	$USER1$/check_postgres_hitratio -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_hot_standby_delay' command definition
#
# Must be run as user postgres
define command {
	command_name	check_postgres_hot_standby_delay
	command_line	$USER1$/check_postgres_hot_standby_delay -H $HOSTADDRESS$ -u postgres
	}

# 'check_postgres_index_size' command definition
define command {
	command_name	check_postgres_index_size
	command_line	$USER1$/check_postgres_index_size -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_last_analyze' command definition
#
define command {
	command_name	check_postgres_last_analyze
	command_line	$USER1$/check_postgres_last_analyze -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_last_autoanalyze' command definition
define command {
	command_name	check_postgres_last_autoanalyze
	command_line	$USER1$/check_postgres_last_autoanalyze -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_last_autovacuum' command definition
define command {
	command_name	check_postgres_last_autovacuum
	command_line	$USER1$/check_postgres_last_autovacuum -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_last_vacuum' command definition
define command {
	command_name	check_postgres_last_vacuum
	command_line	$USER1$/check_postgres_last_vacuum -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_listener' command definition
define command {
	command_name	check_postgres_listener
	command_line	$USER1$/check_postgres_listener -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$
	}

# 'check_postgres_locks' command definition
define command {
	command_name	check_postgres_locks
	command_line	$USER1$/check_postgres_locks -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_logfile' command definition
#
# Requires read permissions to the log file
#define command {
#	command_name	check_postgres_logfile
#	command_line	$USER1$/check_postgres_logfile -H $HOSTADDRESS$ -u pgmonitor
#	}

# 'check_postgres_new_version_bc' command definition
define command {
	command_name	check_postgres_new_version_bc
	command_line	$USER1$/check_postgres_new_version_bc -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_new_version_cp' command definition
define command {
	command_name	check_postgres_new_version_cp
	command_line	$USER1$/check_postgres_new_version_cp -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_new_version_pg' command definition
define command {
	command_name	check_postgres_new_version_pg
	command_line	$USER1$/check_postgres_new_version_pg -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_new_version_tnm' command definition
define command {
	command_name	check_postgres_new_version_tnm
	command_line	$USER1$/check_postgres_new_version_tnm -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_cl_active' command definition
define command {
	command_name	check_postgres_pgb_pool_cl_active
	command_line	$USER1$/check_postgres_pgb_pool_cl_active -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_cl_waiting' command definition
define command {
	command_name	check_postgres_pgb_pool_cl_waiting
	command_line	$USER1$/check_postgres_pgb_pool_cl_waiting -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_maxwait' command definition
define command {
	command_name	check_postgres_pgb_pool_maxwait
	command_line	$USER1$/check_postgres_pgb_pool_maxwait -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_sv_active' command definition
define command {
	command_name	check_postgres_pgb_pool_sv_active
	command_line	$USER1$/check_postgres_pgb_pool_sv_active -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_sv_idle' command definition
define command {
	command_name	check_postgres_pgb_pool_sv_idle
	command_line	$USER1$/check_postgres_pgb_pool_sv_idle -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_sv_login' command definition
define command {
	command_name	check_postgres_pgb_pool_sv_login
	command_line	$USER1$/check_postgres_pgb_pool_sv_login -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_sv_tested' command definition
define command {
	command_name	check_postgres_pgb_pool_sv_tested
	command_line	$USER1$/check_postgres_pgb_pool_sv_tested -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgb_pool_sv_used' command definition
define command {
	command_name	check_postgres_pgb_pool_sv_used
	command_line	$USER1$/check_postgres_pgb_pool_sv_used -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_pgbouncer_checksum_warn' command definition
define command {
	command_name	check_postgres_pgbouncer_checksum_warn
	command_line	$USER1$/check_postgres_pgbouncer_checksum -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$
	}

# 'check_postgres_pgbouncer_checksum_crit' command definition
define command {
	command_name	check_postgres_pgbouncer_checksum_crit
	command_line	$USER1$/check_postgres_pgbouncer_checksum -H $HOSTADDRESS$ -u pgmonitor -c $ARG1$
	}

# 'check_postgres_prepared_txns' command definition
define command {
	command_name	check_postgres_prepared_txns
	command_line	$USER1$/check_postgres_prepared_txns -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_query_runtime' command definition
#define command {
#	command_name	check_postgres_query_runtime
#	command_line	$USER1$/check_postgres_query_runtime -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
#	}

# 'check_postgres_query_time' command definition
define command {
	command_name	check_postgres_query_time
	command_line	$USER1$/check_postgres_query_time -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_relation_size' command definition
define command {
	command_name	check_postgres_relation_size
	command_line	$USER1$/check_postgres_relation_size -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$ -w $ARG2$ -c $ARG3$
	}

# 'check_postgres_replicate_row' command definition
#define command {
#	command_name	check_postgres_replicate_row
#	command_line	$USER1$/check_postgres_replicate_row -H $HOSTADDRESS$ -u pgmonitor
#	}

# 'check_postgres_same_schema' command definition
define command {
	command_name	check_postgres_same_schema
	command_line	$USER1$/check_postgres_same_schema -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_sequence' command definition
define command {
	command_name	check_postgres_sequence
	command_line	$USER1$/check_postgres_sequence -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$
	}

# 'check_postgres_settings_checksum' command definition
define command {
	command_name	check_postgres_settings_checksum
	command_line	$USER1$/check_postgres_settings_checksum -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$ -w $ARG2$ -c $ARG3$
	}

# 'check_postgres_slony_status' command definition
define command {
	command_name	check_postgres_slony_status
	command_line	$USER1$/check_postgres_slony_status -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_table_size' command definition
define command {
	command_name	check_postgres_table_size
	command_line	$USER1$/check_postgres_table_size -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$ -w $ARG2$ -c $ARG3$
	}

# 'check_postgres_timesync' command definition
define command {
	command_name	check_postgres_timesync
	command_line	$USER1$/check_postgres_timesync -H $HOSTADDRESS$ -u pgmonitor
	}

# 'check_postgres_txn_idle' command definition
define command {
	command_name	check_postgres_txn_idle
	command_line	$USER1$/check_postgres_txn_idle -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_txn_time' command definition
define command {
	command_name	check_postgres_txn_time
	command_line	$USER1$/check_postgres_txn_time -H $HOSTADDRESS$ -u pgmonitor -db $ARG1$ -w $ARG2$ -c $ARG3$
	}

# 'check_postgres_txn_wraparound' command definition
define command {
	command_name	check_postgres_txn_wraparound
	command_line	$USER1$/check_postgres_txn_wraparound -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_version' command definition
define command {
	command_name	check_postgres_version
	command_line	$USER1$/check_postgres_version -H $HOSTADDRESS$ -u pgmonitor -w $ARG1$ -c $ARG2$
	}

# 'check_postgres_wal_files' command definition
#
# command requires superuser privileges
#define command {
#	command_name	check_postgres_wal_files
#	command_line	$USER1$/check_postgres_wal_files -H $HOSTADDRESS$ -u pgmonitor
#	}

# uncomment for check_mk legacy checks
#"""