Nagios Support Forum

We have built a new CentOS 7.5 VM and installed NagiosXI 5.5.3 on it, using mariadb for its backend. Our "old" server is running NagioXI 5.4.13, having been updated several times; it is still using postgresql for its backend. We have been able to migrate all the configurations for hosts, services, etc. over to the new host with minimal manual intervention.

How can we migrate the CCM =>Admin => NRDS Config Manager configurations (complete with histories if possible) to the new setup? Is there a recommended process?

These should all restore when you restore a backup.

How would a backup made from a postgresql database be restored to a mariadb/mysql database? I know there are utilities for migrating postgresql to mysql; but are any of them sophisticated enough to handle the complexities of NagiosXI?

dapfox wrote:How would a backup made from a postgresql database be restored to a mariadb/mysql database? I know there are utilities for migrating postgresql to mysql; but are any of them sophisticated enough to handle the complexities of NagiosXI?

We have yet to find a migration utility that can work with consistency on all systems, which is why legacy systems are still using postgres.

What are the table names in which the NRDS Config Manager configurations information is stored, please?

dapfox wrote:What are the table names in which the NRDS Config Manager configurations information is stored, please?

They aren't stored in the database at all, they are read off the filesystem at /usr/local/nrdp/configs/