Server upgrade without postgresql

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
blalande
Posts: 24
Joined: Thu Jan 18, 2018 7:41 am

Server upgrade without postgresql

Post 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
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Server upgrade without postgresql

Post 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.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked