----- Original Message ----- > From: "ml ml" <mliebher...@googlemail.com> > To: "Eli Mesika" <emes...@redhat.com> > Cc: users@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 <emes...@redhat.com> wrote: > > > > > > ----- Original Message ----- > >> From: "ml ml" <mliebher...@googlemail.com> > >> To: users@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@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@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users