check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
I'd like to add a new check that does standby lag based just on pg_last_xact_replay_timestamp() on the standby, without having to connect to the primary. Something akin to: `SELECT EXTRACT(EPOCH...
i tryed "replicate_row", and it was not able to perform the select because of redundant "" on table and column names. the following change fixed the issue: 6546 $table =~...
Add some basic checks for pgpool-II using only SHOW commands
`replicate_row` could use the same discovery technique used by `hot_standby_delay` to detect which of the `--dbhost` arguments is the master. This would make life a lot easier when defining checks...
It's useful to be able to ignore tablespaces when otherwise identical databases are hosted on servers with different hardware capabilities. This commit includes changes to CP_Testing.pm to create some tablespaces...
Hi, i m using your plugin to check if a manual vacuum happened i m using it with the option: last_vacuum - Check the maximum time in seconds since any...
Hello, in Version 2.22.0, check_postgres.pl only returns the parameters total,waiting and exclusive in the performance data, if the amount of these Locks is not null. pnp4nagios fails on reading these...
I have been dealing with a problem in a new installation I was doing today. The problem came up as I saw in Icinga that txn_time and txn_idle were flapping...
I can't get it to check more than one host or port. I've tried both version 2.22.0 and 2.21.0. This is not working as advertised _Connection options can be grouped:...
PGBouncer checks does not take into account possibility when multiple different database users are connected into same database (pool). Here's our `SHOW pools` example: http://pastebin.com/raw/4ybsQCRE Meanwhile, check_postgres output is like...
