Nagios Support Forum

I wish to migrate all my settings from Nagios XI 4 to Nagios XI 5

I have built a new Nagios XI 5 without Postgress.

I had previously upgraded my old Nagios XI 4 to 5 which I believe keeps the PostgresQL database.
(Upgraded installs will continue to use PostgresQL)

Hold do i migrate my settings - from an upgraded Nagios XI 5 with PostgresQL to my new Nagios XI 5 without postgress.

Can the backup and restore script be used?
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

If not how do i migrate all settings from an install with PostgresQL - to an install without PostgresQL

Hi Tony,

Upgraded installs will continue to use PostgresQL and the restore script will correctly identify this.

Just make sure before you do the upgrade from XI 4 TO 5,you run the backup script so that if anything crashes after the upgrade,
your data is safe. But otherwise the backup and restore scripts will you secure your settings. Just make sure you do the backup
before the the upgrade.

Follow the docs below carefully:

https://assets.nagios.com/downloads/nag ... 1493223405

https://assets.nagios.com/downloads/nag ... 1493223405

If anything doesn't seem right then look at....https://support.nagios.com/kb/article/n ... tions.html


Please let me know if you have any questions

i do not think i explained thing clear enough.

I have 2 servers - 2 separate installs

Server 1 - An old Nagios XI 4 server which i have upgraded to Nagios XI V (thus I believe that it keeps the PostgreSQL database)

Server 2 - A newly built Nagios XI V - which i believe has no PostgreSQL database

How do i migrate my settings from the old Server 1 to the new Server 2 which has no PostgreSQL - I want a nice new clean install with no PostgreSQL

Okay i see what you mean.

Here is a doc-...https://support.nagios.com/kb/article/c ... os-xi.html you can follow but make sure you first try it on
a test server before you put it in your clean Nagios xi or production server.

Also be sure to run your backups before trying any of this because i cannot grantee that you might find any errors.

So please try this on a test server first to ensure it works well.

But how do I migrate the othe databases from Server 1 to Server 2

- The nagiossql - Core Config Manager database
- The nagios database - the historical monitoring data - (not worried if I loose this and have to start again)

Hi @tony,

Before i begin,i need you to understand that Nagios XI is the UI which runs on Nagios Core.
So don't let migrating from Nagios core to xi in the doc confuse you its the samething.
Its all Nagios just that XI has more features like wizards and many others. All your configurations apply on both.

So from my understanding,you wish to migrate you configurations form server 1 to server 2 including your historical data.

To migrate your configurations,please follow this doc..https://assets.nagios.com/downloads/nag ... ios_XI.pdf

To migrate historical data,follow this doc...https://support.nagios.com/kb/article/n ... -data.html

Let me know if you have any questions

But what about the data in the XI database like users, views, dashboards etc..

When you create a new user in XI it automatically creates a corresponding contact in Core as well.

So if i migrate only the Nagios core database - will I loose my users as they held in the Nagios XI database?

What else is in the Nagios XI database.

tony wrote: I have built a new Nagios XI 5 without Postgress.

XI is incredibly flexible, but as far as I am concerned, this is where you messed up.

Why not just do an upgrade? If you are changing OSes, just install your version of XI on the new server, then use the backup and restore utility, which will get you postgres.

Is there some reason you don't want postgres? It seems to me like you are making this unnecessarily complicated, but that may be because I don't have the full picture.

Given that Nagios have dropped PostgreSQL then I see no reason why I should keep with it. Therefor we wish to build a nice new clean install without it.

Then if we have any issues in the future we do not need to worry about a re-install including PostgreSQL - better sorting it now than later.

So what's is the easiest way to move from Server 1 with Nagios XI with PostgreSQL to Server 2 without PostgreSQL and to retain all the XI configurations including contacts, views dashboards etc..

Hi @tony,
We don't have an automated process of converting PostgreSQL to MySQL, but you can try following the steps, outlined in the KB article below:
https://support.nagios.com/kb/article/c ... os-xi.html

Upgrade you Nagios XI instance to the latest. It will still be using PostgreSQL, but you can then use the document above to convert it to MySQL. If you follow our backup and restore document, all of the performance data will be preserved.

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Let us know if you get stuck during any of the steps.

Important: Please do a backup prior to trying the conversion. It's best if you try it in a test environment. Don't do it in production right away! Each Nagios XI license is approved for up to three installations: one primary monitoring/production, one backup/failover, and one test environment. Take advantage of this.