check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
The --same_schema action picks up whitespace differences. Can't paste here and see the output, so adding image:  Note the newline between "u.first_name"...
If I have different constraints for two tables, but they have the same name, the --same_schema action will mix them up between the two databases (especially if one database is...
Hi! If I understand the script correctly, the slony-status checks only 1 slave of a cluster, the one which is returned first from the query. This is random. E.g. here...
Hi, On a server I have a large number of databases. I would love it if the multiline nagios plugin output for checks like DB size was only showing the...
I have an error when running the check_postgres_hot_standby_delay function. I issue the following command: ./check_postgres_hot_standby_delay --host=ipprimary --dbuser=user --dbpass=pass --host2=ipsec --dbuser2=user --dbpass2=pass --warning=50 --critical=1024 When I execute this command the response...
Would it be possible to add a filter at application_name as to not check txn_idle for certain applications (for example long pg_dumps)? If so, which would be the best aproach?...
I've used an old alternate monitoring plugin called "check_pg_waiting_queries.pl". It's poorly written, so that when it's run against PostgreSQL 9.1, it always reports "success" when in fact the query contains...
ID: 91 Version: unspecified Date: 2011-11-23 09:07 EST Author: Peter Eisentraut ([email protected]) --- Database test1: ``` create schema foo; create table foo.bar1(a int); create table foo.bar2(a int); ``` Database test2:...
ID: 49 Version: unspecified Date: 2010-09-06 10:25 EDT Author: Martin von Oertzen ([email protected]) --- check_postgres_txn_idle 2.15.0 (from today) results in Status unknown, if there are no idle-transactions at all.
ID: 22 Version: unspecified Date: 2009-12-03 12:58 EST Author: Greg Sabino Mullane ([email protected]) --- Use pg_stattuple to get the bloat information, either as a new action or a flag to...