[Users] Problems accesing the database

[Yedidyah Bar David]

----- Original Message -----
> From: "Juan Pablo Lorier" <jplorier at gmail.com>
> To: "Sahina Bose" <sabose at redhat.com>
> Cc: "users" <users at 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 at 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