----- Original Message -----
From: "Juan Pablo Lorier" <jplorier@gmail.com> To: "Sahina Bose" <sabose@redhat.com> Cc: "users" <users@ovirt.org> Sent: Wednesday, February 12, 2014 7:01:20 PM Subject: [Users] Problems accesing the database
Hi Sahina,
Sorry to ping you directly, but you were of great help last time. I'm also copying the list. In the process of recreating the DC I've decided to migrate the engine from a virtualbox vm to a bare metal host and I can't get engine-backup to restore the engine. Both are Centos 6.5 with engine 3.3.3, but in the new box I can't log to the database with psql -U engine -W The error is:
[root@centos-ovirt ~]# engine-backup --mode=restore --file=/root/backup_20140212.bkp --log=/root/restore.log Restoring... FATAL: Can't connect to the database
I've added to pg_hba.conf the lines I found in the web:
host all all md5
and tryied with the conf from the one that works but nothing. Any clues?
Unlike engine-setup, engine-backup does nothing for you regarding creating the database - it's basically the same as creating a database to be used for a remote-db setup. See e.g. [1] for details, also 'engine-backup --help'. [1] http://www.ovirt.org/OVirt_Engine_Development_Environment#Database -- Didi