check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
With version 2.20.1, the docs say to do: check_postgres.pl --action=replicate_row --host=master --host2=slave1,slave2 But when I tried that I got "ERROR: No slaves found". I did get it to work with:...
2 chsets: - Add support to exclude or include based on application_name. This helps in monitoring long running txn by excluding ones run by particular tools, i.e. pg_dump - Fix...
I think it's reasonable to have some kind of general check that all tables have been vacuumed or analyzed within X days. But if a database has zero tables, then...
hitratio ( and maybe others ) are joining pg_user to pg_database. If the database is owned by a role ( newer versions of PG ), hitratio is not returned: SELECT...
When connecting explicitly by Unix domain socket (rather than over TCP), the output is a bit confusing. To do this, psql and other tools need you to specify the directory...
`check_postgres` tries to determine the server's version in a number of places, in order to craft queries that cope with different catalogs on different server versions. It does so by...
When `custom_query` returns multiple rows, their performance data string is duplicated in subsequent rows. For example: ``` ./check_postgres.pl --action=custom_query --dbname=postgres --dbuser=peisentraut --warning=100 --query="select 30 as result, 'foo' as data union...
We're using check_postgres to email alerts out to interested parties on a select number of actions, one of which is query_time to help identify long running queries. I keep getting...
Check how long the first (oldest) client in queue has been waiting. The suggested check is more comprehensive than pgb_pool_maxwait, it supports warning and critical time limits, exclude/include database options,...
check_postgres works well. If I receive an error or warning, I know that something is wrong. But I can't see what is going on. It would be great to see...
