check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
ID: 53 Version: unspecified Date: 2010-11-03 12:42 EDT Author: Peter Eisentraut ([email protected]) --- I run ``` perl Makefile.PL make make install ``` and the resulting installation is ``` /usr/local/share/perl/5.10.1/check_postgres.pl /usr/local/man/man3/check_postgres.3pm...
When doing a --reverse check with custom_query and using both warning and critical values, the result is always OK. This is caused by the sub validate_range () which returns no...
i created a unique index concurrently. after it was build, i droped the old index. nagios reports [2011-02-16 16:48:05] SERVICE ALERT: pg1;PG-bloat; CRITICAL;HARD;10;CHECK_NRPE: Socket timeout after 30 seconds. [2011-02-16 16:52:45]...
When i'm try to check th database from my supervision server the --host, the -H and the --dbhost parmeters are igored. they only try to connect on localhost. I'have more...
Postgresql can be setup to replicate from a server in recovery mode to another server in recovery mode. This change allows this scenario for check_hot_standby_delay. Scenario: db1(not in recovery) ->...
A certificate check would be useful. re: https://nagios-plugins.org/doc/man/check_http.html This URL indicates there is a `starttls` command: https://dba.stackexchange.com/questions/108710/how-to-examine-postgresql-servers-ssl-certificate e.g. `openssl s_client -starttls postgres -connect pg03.example.org:5432`
Hi, When using alldb option in presence of (some) .psqlrc, fetching list of databases failed. ``` $ ./check_postgres.pl --action relation_size -w 1 -c 100 --perflimit 2 --alldb POSTGRES_RELATION_SIZE CRITICAL: DB...
When using alldb option in presence of (some) .psqlrc, fetching list of databases failed. This PR disable .psqlrc by adding -X option.
`check_postgres.pl --action query_time -c 30 -w 10` returns the sql statement in the output. I am not sure if its possible that data is displayed e.g. when using insert, update...
Thank you for the wonderful tool. Definitely a swiss army knife of PostgreSQL tools. I needed to check the documentation for check_postgres.pl and I clicked on the link `https://bucardo.org/check_postgres/check_postgres.pl.html` from...
