[ovirt-users] engine-backup

[Eli Mesika]

----- Original Message -----
> From: "ml ml" <mliebherr99 at googlemail.com>
> To: "Eli Mesika" <emesika at redhat.com>
> Cc: users at ovirt.org
> Sent: Wednesday, October 1, 2014 12:54:13 PM
> Subject: Re: [ovirt-users] engine-backup
> 
> Thanks, that did the trick.
> 
> Its mentioned in the engine-backup --help dialog. But maybe we should
> add it to the http://www.ovirt.org/Ovirt-engine-backup page, too?

I have added the correct empty DB creation command to the wiki page.


> 
> On Wed, Oct 1, 2014 at 11:16 AM, Eli Mesika <emesika at redhat.com> wrote:
> >
> >
> > ----- Original Message -----
> >> From: "ml ml" <mliebherr99 at googlemail.com>
> >> To: users at ovirt.org
> >> Sent: Wednesday, October 1, 2014 12:07:59 PM
> >> Subject: [ovirt-users] engine-backup
> >>
> >> Hello List,
> >>
> >> i am trying to restore my ovirt-engine on a fresh installed machine.
> >>
> >> I followed: http://www.ovirt.org/Ovirt-engine-backup
> >>
> >>
> >> So i did:
> >> - yum install ovirt-engine
> >> - engine-setup
> >> - engine-cleanup
> >>
> >> su - postgres -c "createdb -U postgres engine"
> >
> > Should be :
> >
> > su - postgres -c "psql -d template1 -c \"create database engine owner
> > engine;\" "
> >
> > please do :
> >
> > dropdb -U postgres engine
> >
> > and retry using the above command for db creation
> >
> >
> >> as postgres i also set my original passwort for the engine postgres user:
> >> alter role engine ENCRYPTED PASSWORD 'foo\bar';
> >>
> >> My Restore Command was:
> >> engine-backup --mode=restore --file=backup --log=LOG_FILE
> >> --change-db-credentials --db-host=localhost --db-user=engine
> >> --db-name=engine --db-password
> >>
> >>
> >> [root at ovirt ~]# engine-backup --mode=restore --file=backup
> >> --log=LOG_FILE --change-db-credentials --db-host=localhost
> >> --db-user=engine --db-name=engine --db-password
> >> Enter Engine database password:
> >> Preparing to restore:
> >> - Setting credentials for Engine database 'engine'
> >> - Unpacking file 'backup'
> >> Restoring:
> >> - Files
> >> - Engine database 'engine'
> >> FATAL: Errors while restoring database engine
> >>
> >> ...
> >>
> >> SET
> >> CREATE TABLE
> >> ALTER TABLE
> >> CREATE VIEW
> >> ALTER TABLE
> >> CREATE VIEW
> >> ALTER TABLE
> >> ERROR:  function fn_get_disk_commited_value_by_storage(uuid) does not
> >> exist
> >> ZEILE 2: ...disk_size, storage_domain_dynamic.used_disk_size,
> >> fn_get_dis...
> >>                                                               ^
> >> TIP:  No function matches the given name and argument types. You might
> >> need to add explicit type casts.
> >> ERROR:  relation "public.storage_domains_for_search" does not exist
> >> ERROR:  function fn_get_disk_commited_value_by_storage(uuid) does not
> >> exist
> >> ZEILE 2: ...disk_size, storage_domain_dynamic.used_disk_size,
> >> fn_get_dis...
> >>                                                               ^
> >> TIP:  No function matches the given name and argument types. You might
> >> need to add explicit type casts.
> >> ERROR:  relation "public.storage_domains_with_hosts_view" does not exist
> >> CREATE VIEW
> >> ALTER TABLE
> >> CREATE VIEW
> >> ALTER TABLE
> >> ERROR:  function fnsplitteruuid(text) does not exist
> >> ZEILE 2:     (SELECT users.user_id, fnsplitteruuid(users.group_ids) A...
> >>                                     ^
> >> TIP:  No function matches the given name and argument types. You might
> >> need to add explicit type casts.
> >>
> >>
> >>
> >> Any ideas what i did wrong and why it wont restore the DB?
> >>
> >> Thanks,
> >> Mario
> >> _______________________________________________
> >> Users mailing list
> >> Users at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
>