[ovirt-users] engine-backup

[Eli Mesika]

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