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
Server upgrade without postgresql
Re: Server upgrade without postgresql
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.
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.
Be sure to check out our Knowledgebase for helpful articles and solutions!