convert the nagiosxi db from postgres to mysql?

[warapp]

I am running nagiosxi 5.4.13. Today, I noticed that the dbtype is pgsql. The nagiosxi db is held here, and the nagios and nagiosql db's are held in mysql. I see the article on how to convert the nagiosxi db from postgres to mysql.

Should I convert nagiosxi db to mysql using instructions here,
https://support.nagios.com/kb/article/c ... i-560.html
or leave well enough alone?

I am planning to upgrade xi within the next couple of weeks to 5.6.12.

-wr

[benjaminsmith]

Hi WR,

You have either option: leave it as postgres or migrate to mysql. The upgrade script will handle either case. We have quite a few customers using the older Postgres database without issue but if you might find it easier to administer if everything is running on mysql.

If you are on VM, this is helpful as you can revert back if needed when performing the migration.

[warapp]

Thanks for the reply. You say the upgrade script will handle either case. Do you mean the upgrade steps here, https://assets.nagios.com/downloads/nag ... ctions.pdf

I've run through several xi upgrades and never been presented with an option to convert nagiosxi db from postgres to mysql. I would like to consolidate and use mysql exclusively.

Thanks again for any help you can provide.

-wr

[benjaminsmith]

Hello,

Apologies for any misunderstanding, the upgrade script will just leave it as Postgres and continue on. To migrate the database to MySQL, please follow the steps in the guide.

Let us know if you need any assistance. Be sure to take a backup before making any changes to the production server.