Nagios Support Forum

i'm having a server running 5.2.3 and trying to restore everything to another server so it has the exact copy.

1. install brand new version of 5.2.3 to new server.
2. make a back up from existing server.
3. move back up file to new server and doing restore.

got following errors.

./restore_xi.sh /www/backups/nagiosxi/1477340370.tar.gz
TS=1477403758
Extracting backup to /store/backups/nagiosxi/1477403758-restore...
In /store/backups/nagiosxi/1477403758-restore/1477340370...
Backup files look okay. Preparing to restore...
Shutting down services...
Stopping nagios:/etc/init.d/nagios: line 142: kill: (20594) - No such process
done.
ndo2db was not running... could not stop
NPCD was not running.
Restoring directories to /...
Restoring Nagios Core...
Restoring Nagios XI...
Restoring NagiosQL...
Restoring NagiosQL backups...
Restoring NRDP backups...
Restoring MRTG...
Restoring Nagvis backups...
Restoring MySQL databases...
Starting postgresql service: [ OK ]
Restoring Nagios XI PostgresQL database...
psql: FATAL: Ident authentication failed for user "nagiosxi"
Error restoring PostgresQL database 'nagiosxi' !

My guess, is your previous installation was probably running as an upgrade from a previous version. The newer versions of Nagios use MySQL moving forward, but in the past we used postgres.

Are you able to create a postgres username for nagiosxi on the new machine? You may need to do this manually.

yes this works fine. thanks

That's great, is it okay to lock this thread then?

yes, thanks.