check_postgres
check_postgres copied to clipboard
Nagios check_postgres plugin for checking status of PostgreSQL databases
This addresses issue #150.
This PR adds performance data for the `dbstats` action (something I personally was missing for years). The performance data was tested with all databases: ``` $ ./check_postgres.pl --action dbstats --dbpass...
Hello and thanks for this great plugin! When using the `--include` parameter to specify a database, the output still shows `DB "postgres"`. This is confusing. In the performance data however...
This type of misconfiguration leads to failures of partition_data_proc
our $VERSION = '2.26.0'; check_postgres.pl -db postgres --action partman_premake Array found where operator expected at /tmp/check_postgres.pl line 3438, at end of line (Missing operator before ?) syntax error at /tmp/check_postgres.pl...
Currently the --alldb option doesnt use the defaultuser / dbuser for psql, so an error is returned when the os user who started the script doesnt have acces to postgres.
The check_pgb_pool function generates metrics per database. But [PgBouncer SHOW POOLS](https://www.pgbouncer.org/usage.html) generates a tuple of database and user per row. So if we have a database exampledb and SHOW POOLS...
When running `t/05_docs.t`, test fails with a bunch of errors : ``` t/05_docs.t ................ 1/4 # Failed test 'Docs out of order: expected partman_premake in POD section, but got pgb_pool_cl_active...