search

bucardo / check_postgres

Nagios check_postgres plugin for checking status of PostgreSQL databases
http://bucardo.org/wiki/Check_postgres
Other
551 stars 174 forks source link

alldb option doesn't work because of .psqlrc #207

Open F-S-T opened 5 months ago

F-S-T commented 5 months ago

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 "" largest relation is table "pg_catalog.pg_proc": 784 kB | time=0.02s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=532480B;1;100

If we remove .psqlrc it works:

$ ./check_postgres.pl --action relation_size -w 1 -c 100 --perflimit 2 --alldb
POSTGRES_RELATION_SIZE CRITICAL: DB "postgres" largest relation is table "pg_catalog.pg_proc": 784 kB DB "repmgr" largest relation is table "pg_catalog.pg_proc": 784 kB DB "template1" largest relation is table "pg_catalog.pg_proc": 784 kB DB "toto" largest relation is table "public.big": 35 MB | time=0.01s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=532480B;1;100 time=0.03s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=540672B;1;100 time=0.03s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=532480B;1;100 time=0.03s public.big=36175872B;1;100 pg_catalog.pg_proc=802816B;1;100

Regards, FST

F-S-T commented 5 months ago

PR: https://github.com/bucardo/check_postgres/pull/208