<p dir="ltr">Hi Eli,</p>
<p dir="ltr">I omitted to post that, but I did use them. It seems that others had trouble too as the database is owned by postgres after the restore and it's needed to change the engine user's password when the restore is on a different host. Thanks to all the ones that posted helpful tips, tomorrow I'll try those tips and tell the ending.<br>
Regards,</p>
<div class="gmail_quote">El 12/02/2014 19:38, "Eli Mesika" <<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>> escribió:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
----- Original Message -----<br>
> From: "Juan Pablo Lorier" <<a href="mailto:jplorier@gmail.com">jplorier@gmail.com</a>><br>
> To: "Yedidyah Bar David" <<a href="mailto:didi@redhat.com">didi@redhat.com</a>><br>
> Cc: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
> Sent: Wednesday, February 12, 2014 7:55:35 PM<br>
> Subject: Re: [Users] Problems accesing the database<br>
><br>
> Hi Yedidyah,<br>
><br>
> But If I run engine-setup and then engine-backup restore shuldn't it<br>
> import the data to the existing db created by engine-setup?<br>
> That's shown everywhere so I thought it's a valid way to migrate<br>
> Regards,<br>
<br>
Hi<br>
<br>
Why aren't you using the --db-user --db-password parameters , its seems that you fail to authenticate<br>
<br>
><br>
> On 12/02/14 15:44, Yedidyah Bar David wrote:<br>
> > ----- Original Message -----<br>
> >> From: "Juan Pablo Lorier" <<a href="mailto:jplorier@gmail.com">jplorier@gmail.com</a>><br>
> >> To: "Sahina Bose" <<a href="mailto:sabose@redhat.com">sabose@redhat.com</a>><br>
> >> Cc: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
> >> Sent: Wednesday, February 12, 2014 7:01:20 PM<br>
> >> Subject: [Users] Problems accesing the database<br>
> >><br>
> >> Hi Sahina,<br>
> >><br>
> >> Sorry to ping you directly, but you were of great help last time. I'm<br>
> >> also copying the list.<br>
> >> In the process of recreating the DC I've decided to migrate the engine<br>
> >> from a virtualbox vm to a bare metal host and I can't get engine-backup<br>
> >> to restore the engine.<br>
> >> Both are Centos 6.5 with engine 3.3.3, but in the new box I can't log to<br>
> >> the database with psql -U engine -W<br>
> >> The error is:<br>
> >><br>
> >> [root@centos-ovirt ~]# engine-backup --mode=restore<br>
> >> --file=/root/backup_<a href="tel:20140212" value="+59820140212">20140212</a>.bkp --log=/root/restore.log<br>
> >> Restoring...<br>
> >> FATAL: Can't connect to the database<br>
> >><br>
> >> I've added to pg_hba.conf the lines I found in the web:<br>
> >><br>
> >> host all all md5<br>
> >><br>
> >> and tryied with the conf from the one that works but nothing.<br>
> >> Any clues?<br>
> > Unlike engine-setup, engine-backup does nothing for you regarding<br>
> > creating the database - it's basically the same as creating a database<br>
> > to be used for a remote-db setup. See e.g. [1] for details, also<br>
> > 'engine-backup --help'.<br>
> ><br>
> > [1] <a href="http://www.ovirt.org/OVirt_Engine_Development_Environment#Database" target="_blank">http://www.ovirt.org/OVirt_Engine_Development_Environment#Database</a><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
><br>
</blockquote></div>