New_Version_restore.sh not working.

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
taycom
Posts: 4
Joined: Fri Sep 20, 2013 5:49 am

New_Version_restore.sh not working.

Post by taycom »

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 ~]#
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: New_Version_restore.sh not working.

Post by Box293 »

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
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
taycom
Posts: 4
Joined: Fri Sep 20, 2013 5:49 am

Re: New_Version_restore.sh not working.

Post by taycom »

Hello.

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

Thanks for your reply.
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: New_Version_restore.sh not working.

Post by hsmith »

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?
Former Nagios Employee.
me.
taycom
Posts: 4
Joined: Fri Sep 20, 2013 5:49 am

Re: New_Version_restore.sh not working.

Post by taycom »

Close the ticket and thanks for you reply
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: New_Version_restore.sh not working.

Post by rkennedy »

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