check_postgres.pl sequence error on d.adsrc

[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

[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...

[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.

[kg2857]

Sorry I misunderstood...

[jsimon]

Hi Christian,

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