upgrade Postgres of NagiosXI

[TethiS]

Hi,

We have a clustered XI instance at one of our customers running XI 5.7.3 version (on RHEL 7.9).
After a security sweep on the servers the customer would like to have the postgres package installed by Nagios upgraded from 9.2.24 to 9.3.23 / 9.4.18 / 9.5.13 / 9.6.9 / 10.4 or later.

Code: Select all

>rpm -qa|grep postgres
postgresql-server-9.2.24-7.el7_9.x86_64
postgresql-9.2.24-7.el7_9.x86_64
postgresql-libs-9.2.24-7.el7_9.x86_64

Is there a known path of doing this without risking to break the functionality of the NagiosXI ?

Thanks!

[vtrac]

Hi,
How are you doing?

PostgreSQL(the default database prior to Nagios XI 5)
MySQL/MariaDB (the default database since Nagios XI 5)

I would suggest that you "manually" convert Postgres to Mysql/Mariadb as this is the default DB used in Nagios XI today.

If you are on RHEL / CentOS 7.9, the default database is Mariadb.

Here's the KB article for converting Postgres to Mariadb:
https://support.nagios.com/kb/article/c ... i-560.html

As always, please test this out on your development system first before doing production ...


Best Regards,
Vinh

[TethiS]

Hi vinh,

all good here, hope the same for you

Actually, the mysql is already used for the Nagios XI config. Postgres is NOT running but I think the customer just wants to be "square" about the security thing. Their tool just connects to the host then finds the /usr/bin/postgres binary and checks for the version.

I've already tried to completely remove the postgres package but I was warned that it is a package required by the nagiosxi package:

Code: Select all

[root@vlrpsysmnt01 bin]# rpm -qa|grep postgres
postgresql-server-9.2.24-7.el7_9.x86_64
postgresql-9.2.24-7.el7_9.x86_64
postgresql-libs-9.2.24-7.el7_9.x86_64
[root@vlrpsysmnt01 bin]# rpm --erase postgresql-server-9.2.24-7.el7_9.x86_64
error: Failed dependencies:
        postgresql-server is needed by (installed) nagiosxi-5.7.3-2.el7.x86_64

So.. If I manually update the postgresql packages the nagiosxi will not complain or anything..?

thanks again,
Seb

[vtrac]

Hi Seb,
I'm good as well ... Thanks!! ...

So.. If I manually update the postgresql packages the nagiosxi will not complain or anything..?

Based on the info provided, yes I think it is OK to manually upgrade Postgres since it it NOT being used by Nagios XI.

It is always a good idea to take a snapshot of the VM before doing any work on the system ...


Best Regards,
Vinh

[TethiS]

Hi,

I removed the postgresql packages with --nodeps option then installed a more recent version (just in case it was needed) and all seems fine.

Thread can be locked.

Seb

[vtrac]

Great!! .... locking thread ...


Vinh