check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
We run a 4 node setup where we have a hot standby and a cascading replication setup like: ``` A -> B | C -> D ``` where A is...
Is it possible to exclude a query from the query_time check ? Every night I get one alert about `query:autovacuum: VACUUM aaa.bbb` I tried blindly `--exclude=~vacuum` but it doesn't seem...
Hello, It would be appreciated to add availability perfdata to "connection" action like this command : check_postgres.pl --action "connection" --host HOST --port 5432 --dbuser USER --showperf=1 --timeout 5 --showtime=0 OK...
I've got 2 machines, one with PostgreSQL 10 running (DB), and one with other services including Nagios Core (lets call it just Nagios). I've installed NRPE on DB machine alongside...
Sorry to do another pull request on this, especially since this one is slightly more disruptive. I just discovered a number of problems while trying to monitor more of our...
Due to the inclusion of the offending Query in the output of the "query_time" action and others (f958d61e), the output produced by those actions can contain essentially arbitrary data. The...
The same_schema check needs rewriting for PG12: ``` t/02_same_schema.t .. 1/76 # Failed test 'Action 'same_schema' succeeds with two empty databases' # at t/02_same_schema.t line 63. # 'ERROR: column "proisagg"...
[lockwait.patch.zip](https://github.com/bucardo/check_postgres/files/2649719/lockwait.patch.zip) Added a check I thought was missing. It checks for locks which have been blocking for more than specified time. Tested on 9.6 and 10.6
It would be nice if you could add a note in the docs how to use check_postgres to monitor logical replication (pglogical). I was told that check_postgres should already support...
