Page 1 of 1
upgrade Postgres of NagiosXI
Posted: Thu Jul 29, 2021 5:48 am
by 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!
Re: upgrade Postgres of NagiosXI
Posted: Thu Jul 29, 2021 1:18 pm
by 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
Re: upgrade Postgres of NagiosXI
Posted: Thu Jul 29, 2021 2:03 pm
by 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
Re: upgrade Postgres of NagiosXI
Posted: Thu Jul 29, 2021 2:29 pm
by 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
Re: upgrade Postgres of NagiosXI
Posted: Tue Aug 03, 2021 2:22 am
by 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
Re: upgrade Postgres of NagiosXI
Posted: Tue Aug 03, 2021 9:07 am
by vtrac
Great!! .... locking thread ...
Vinh