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" 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
----- Original Message -----
From: "ml ml" <mliebherr99@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
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@redhat.com> wrote:
----- Original Message -----
From: "ml ml" <mliebherr99@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
----- Original Message -----
From: "ml ml" <mliebherr99@googlemail.com> To: "Eli Mesika" <emesika@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 <emesika@redhat.com> wrote:
----- Original Message -----
From: "ml ml" <mliebherr99@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
participants (2)
-
Eli Mesika -
ml ml