Page 1 of 1

check_postgres.pl sequence error on d.adsrc

Posted: Fri Aug 29, 2025 3:38 am
by CBoekhuis
Hi,

After update from 2024R2 to 2024R2.1 also the check_postgres.pl plugin is updated. However this pluging throughs an error related to the postgres DB version (ERROR: column d.adsrc does not exist) . The installed version 2.21 of the plugin does not work correctly when checking the sequence on pg version 15. Version 2.26 of the plugin does. It would be nice that newer version will be deployed on upgrade or installation of nagiosxi.
Since postgres12 the adscr colomn is deprecated and also postgres12.22 is not supported anymore.

Regards,
Christian

Re: check_postgres.pl sequence error on d.adsrc

Posted: Fri Aug 29, 2025 7:10 pm
by kg2857
You probably want to convert Postgres to Mysql since nagios stopped using it on new installs about a dozen releases and several years ago...

Re: check_postgres.pl sequence error on d.adsrc

Posted: Sat Aug 30, 2025 1:08 am
by CBoekhuis
The plugin used to monitor other postgres databases. Of course nagiosxi itself runs on mysql. But de plugin that is used also to monitor other DB's that is installed is outdated.

Re: check_postgres.pl sequence error on d.adsrc

Posted: Sat Aug 30, 2025 1:52 am
by kg2857
Sorry I misunderstood...

Re: check_postgres.pl sequence error on d.adsrc

Posted: Tue Sep 02, 2025 9:29 am
by jsimon
Hi Christian,

Thanks for reaching out! I've created an internal issue to update this plugin.