check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
Allow `custom_query` checks with multiple rows of output to populate the second returned column as the perfdata variable name. Pass the result value as the perfdata value. Helpful for `count(*)...
https://bucardo.org/check_postgres/check_postgres.pl.html `check_postgres_replication_slots` is missing, for example.
If the WAL directory (pg_xlog or pg_wal) resolves to a symbolic link, e.g. "../some-wal-dir", the check fails with an error like: ERROR: Invalid result from command "/bin/df -kP "../some-wal-dir" 2>&1":...
Check does seem to go ok: ``` Use of uninitialized value $check_postgres::opt{"output"} in lc at /usr/lib64/nagios/plugins/postgres/check_postgres_connection line 711. POSTGRES_CONNECTION OK: DB "icinga" (host:icinga-postgres-01) version 9.2.2 ``` command used: ``` postgres/check_postgres_connection...
The password will be cut where the comma is. Still looking for a way to escape it. Thanks
Check all replication slots and raise a warning is a slot is not active and hasn't been used or a critical alert if the slot has been used. check_postgres_replication_active_slots --port=5432...
When doing the PgBouncer checks (pgb_pool_cl_active, etc.) the perfdata produced are only "time" entries, and it produces two time values - not sure if it is one for each pool...
make sure the bloat check's minimum size requirements for tables and indexes match the documentation. This was broken in commit b0ea851392d27df838a7011667858382550496be, and the documented behaviour gives better results than the...
Running check_postgres_connection v2.23.0 produces different output to v2.22.0 **v2.22.0** 1. Postgresql cluster running... # check_postgres_connection --db=postgres --host=ieavu02 --output=simple Output = 1 2. Postgresql cluster shutdown..... # check_postgres_connection --db=postgres --host=ieavu02 --output=simple...
1. Method custom_query displays result from column "result": ``` my $result = $r->{result}; add_critical "$result"; ``` Is it possible to return data from another column e.g. display: ``` my $display=...
