Re: [Users] engine-backup --restore

From: "Juan Pablo Lorier" <jplorier(a)gmail.com&gt; To: "Yedidyah Bar David" <didi(a)redhat.com&gt; Cc: "users" <users(a)ovirt.org&gt; Sent: Wednesday, February 12, 2014 9:10:43 PM Subject: Re: [Users] engine-backup --restore Well, too soon to say boodbye. Thought I used --change-db-credentials in the restore, the engine seems to be unable to connect to the database. I assume that it didn't get the new password, so, is there a way to tell the engine about the new password? Regards,

On 12/02/14 16:03, Yedidyah Bar David wrote: > ----- Original Message ----- >> From: "Juan Pablo Lorier" <jplorier(a)gmail.com&gt; >> To: "Yedidyah Bar David" <didi(a)redhat.com&gt; >> Cc: "Sahina Bose" <sabose(a)redhat.com&gt;, "users" <users(a)ovirt.org&gt; >> Sent: Wednesday, February 12, 2014 7:55:35 PM >> Subject: Re: [Users] Problems accesing the database >> >> 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 > No. > > There is a specific case in which this works automatically: > All on the same host: > 1. engine-setup > 2. engine-backup --mode=backup > (perhaps do other stuff here) > 3. engine-cleanup > 4. engine-backup --mode=restore > > Why does this work? Because 'engine-cleanup', since 3.3, does not drop > the database nor user inside postgres. So when restore tries to access > this database using this user and password it succeeds. > > In general, if you do the restore on another machine, and do there > 'engine-setup; engine-cleanup' as a quick-postgres-provisioning-tool, > you end up almost ready, but not quite - because the password is random, > and therefore different between the installations. In principle you could > have provided just the password to restore, but we decided that if you > need to change the credentials, you should pass all of them (except for > defaults). > > Hope this clarifies, _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users