Page 1 of 1

Server upgrade without postgresql

Posted: Tue Jun 19, 2018 7:18 am
by blalande
Hello,

is there a documented and supported way to upgrade a Nagios XI 2014R2.7 server to a newer version, and get rid of the postgresql db?
In addition the server is running in an offline environment.

So far I've found documentation on how to migrate a server (backup and restore on freshly installed server), but nothing to upgrade and use only mysql databases...

Thanks in advance
BL

Re: Server upgrade without postgresql

Posted: Tue Jun 19, 2018 3:30 pm
by tgriep
Converting the Postgress database to MYSQL on the older versions of XI may have some issues.
The safest thing is to upgrade XI on the server and make sure it is functional.
Then convert the Postgres database to MYSQL.
I feel that would be the safest way of doing this.

This document has a section in it for upgrading XI in an offline environment.
https://assets.nagios.com/downloads/nag ... onment.pdf

This KB article has the steps needed to convert the database.
https://support.nagios.com/kb/article/c ... i-560.html

One thing, make sure you do a full backup of the server before and between the steps in case you need to go back.