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?
On Wed, Oct 1, 2014 at 11:16 AM, Eli Mesika <[email protected]> wrote: > > > ----- Original Message ----- >> From: "ml ml" <[email protected]> >> To: [email protected] >> 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 >> [email protected] >> http://lists.ovirt.org/mailman/listinfo/users >> _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
