Re: [Users] Problems accesing the database
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--mIHNOnbAdv7XaOQQMDkivlTdk39pnJU5G
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hi Yedidyah,
But If I run engine-setup and then engine-backup restore shuldn't it
import the data to the existing db created by engine-setup?
That's shown everywhere so I thought it's a valid way to migrate
Regards,
On 12/02/14 15:44, Yedidyah Bar David wrote:
----- Original Message -----
> From: "Juan Pablo Lorier" <jplorier(a)gmail.com>
> To: "Sahina Bose" <sabose(a)redhat.com>
> Cc: "users" <users(a)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-backu=
p
> 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=3Drestore
> --file=3D/root/backup_20140212.bkp --log=3D/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
--mIHNOnbAdv7XaOQQMDkivlTdk39pnJU5G
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQEcBAEBAgAGBQJS+7WXAAoJEC5KDDg2+NMMEE0IAKF2jvNEtrs0kf7BllGcT52N
UJ8YAGrCdWMUZ+A4gf/LAy7ehDtlPCuLDhrVgmUDVBggruU0EcVPKIEI5gtjtK2t
MWw/3ADb4iYXg467ZXZ8GlAYhzz1i/WSwJyJYGRQIaHlcRG7xvFhekCsSOJBrhlK
0Z9IeG+kkFjhQWzm+V5WUkeW5Uh2E44aWd7gNfMStmZIaw9/AATelRWhwxoyelyu
Js+QweuVcQYyL0flmwIB2tfHBAcuFWrOiVXkMib9l/uCeGqquzIOB0pEhRPnkaiI
5YMWi7MMD0B8NpCHP+1N0Z2CQfW3nCwJokzrUbGseIOpgMoxq9C69MdMbQCl4KM=
=SCAu
-----END PGP SIGNATURE-----
--mIHNOnbAdv7XaOQQMDkivlTdk39pnJU5G--
Attachments:
- attachment.bin (multipart/signed — 2.5 KB)