[ovirt-users] engine-backup

[ml ml]

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