Nagios Support Forum

I'm running an old Nagios VM that has been updated regularly (currently on XI 5.4.2).
I would like to spin up a new Nagios VM and migrate the data from the old to the new.
I understand that the new VM doesn't have Postgres - how do I recover the Nagios Backup file to the new environment ?

regards... Fred

Can you install Postgres on the new server before restoring the backup?
The restore script should detect that the backup file has the Postgres database backed up in it and then restore it to the new server.
The other option is to convert the Postgres database to MYSQL on the old server, back it up and restore it to the new server.
To convert the database to mysql, take a look at this KB article.
https://support.nagios.com/kb/article.php?id=560

Make sure you do a full backup of the old server in case you need to go back.

Thanks - the second option sounds like what I was looking for.
So basically I need to migrate the Postgres d/base to MySQL before I can import it into a fresh VM ?
I'm not sure how others feel, but this blows a big hole in my DR plans! If I ever needed to spin up another Nagios Instance because of some disaster, I just download a new VM and recover from the last backup file . We would be up & running again in a very short time. I suppose I could manually install postgres, but this complicates what was a very simple process.

BTW - are there any plans to provide a CentOS-7 NagiosXI VM ?

Fred

The VM's that you can download from the Nagios site already has postgres installed so that would be easy to do, if you install your own OS, that is where you need to install postgres manually.
I don't have any information on providing Centos7 in the Nagios provided VM's.

Thanks - I'm guessing the NagiosXI roadmap would lead to not using postgres as the preference ?

postgresql in Nagios XI is deprecated as of right now, but there's no timeline for completely removing it (as of right now).