Skip to content

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

@F-S-T

Description

@F-S-T

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions