Nagios Support Forum

Hello.

The problem is in the upgrade from other Nagiox XI 2014 to the new versión.

When I perform the command and is in the process always ends showing an error , as I can solve the problem and restore my old settings . Thanks

[root@NagiosXI ~]# /usr/local/nagiosxi/scripts/restore_xi.sh /root/1447687605.tar.gz
TS=1447714473
Extracting backup to /store/backups/nagiosxi/1447714473-restore...
In /store/backups/nagiosxi/1447714473-restore/1447687605...
Backup files look okay. Preparing to restore...
Shutting down services...
Stopping nagios:.. done.
Stopping ndo2db: done.
NPCD Stopped.
Restoring directories to /...
Restoring Nagios Core...
Restoring Nagios XI...
Restoring NagiosQL...
Restoring NagiosQL backups...
Restoring NRDP backups...
Restoring MRTG...
Restoring MySQL databases...
Restoring PostgresQL databases...
psql : could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket " /tmp/.s.PGSQL.5432 "?
Error restoring PostgresQL database 'nagiosxi' !
[root@NagiosXI ~]#

In XI 5 we are phasing out the Postgres Database. Currently when you upgrade from 2014 to 5 the postgres database is still used. However in a fresh install it does not get used. The developers are currently working on a migration script to your upgraded XI server can have postgres removed.

The problem right now is that when you try to restore your current XI 5 backup (which was upgraded from 2014) it still needs postgres. Your fresh server you are trying to restore to does not include postgres and hence the restore is failing.

The steps you need to follow to restore your XI 5 backup (which was upgraded from 2014) are:

* Install Nagios XI 2014R2.7 on the new server (it is preferable to have a "clean" install on the same OS/Architecture as on the old server)
* Upgrade this fresh install to XI 5.x
* Restore from the backup

Hello.

We'll wait until we have the converter postgre > mysql

Thanks for your reply.

We do not have a script for this at the moment, and I can't promise what the ETA would be on one. If you're going to wait, would you like me to close the thread?

Close the ticket and thanks for you reply

Sounds good. I'll close this out. If you ever have any more questions, don't hesitate to open a new thread.