----- 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
