Nagios Support Forum

Hi Everyone,

After upgrading to the latest version 2026R1.4, All my service checks related to check_postgres.pl are showing UNKNOWN state with the below output which used to be working fine until the update.


POSTGRES_CONNECTION UNKNOWN: DB "postgres" (host:11.18.01.187) Invalid query returned: PostgreSQL 16.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit\n


I am trying to verify the DB availability using the below qurery to which i am seeing above output


./check_postgres.pl -H IPADDRESS -p PORT --dbuser nagiosuser --dbpass Password -dbname dbna --action connection


I could see my other services using the plugin "check_postgresql_role_custom.sh " is working fine.

I am unable to identify the issue why it is happening but if anyone is able to help, It will be very much appreciated.

Thanks in advance

Hey Guys, Quick update

I have update the check_postgres.pl plugin with the latest version from https://github.com/bucardo/check_postgr ... ostgres.pl, and seems everything is working for me


Thanks

Hi @DileepKumar,

Thanks for your note.

The next release of Nagios XI will update this plugin to 2.26.0.

Aaron