hi, I do test to understand my problem I do a fresh install of an EL-Based Self-Hosted Engine see https://ovirt.org/documentation/self-hosted/chap-Deploying_Self-Hosted_Engin... REM : "hosted-engine --deploy" don't ash for storage so do hosted-engine --deploy --noansible I do a full backup of the engine https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/#... cleanup, restore with this backup https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/#... restore is ok : I do same think with my backup (v4.2.3) but same error on engine database : pg_restore: [archiver (db)] Error from TOC entry 1244; 1255 2004229 FUNCTION uuid_generate_v1() engine pg_restore: [archiver (db)] could not execute query: ERROR: function "uuid_generate_v1" already exists with same argument types Command was: CREATE FUNCTION uuid_generate_v1() RETURNS uuid LANGUAGE plpgsql STABLE AS ' DECLARE v_val BIGINT; v_4_1_par... pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of function uuid_generate_v1 Command was: ALTER FUNCTION public.uuid_generate_v1() OWNER TO engine; notice database created with 4.1 and upgrade to 4.2 How can I check the database ? clean up ? Do I create a bug report ? Regards, -- Emmanuel Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit :
Hi, adding also Didi here. We'll try to reproduce, in the mean time, can you please share engine-backup logs at backup and restore times? thanks
On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel <emmanuel.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/>
But like others, i can't restore database
I Have :
pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 7397; 0 0 COMMENT EXTENSION plpgsql pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
..
...
Any solution ?
emmanuel _______________________________________________ Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> To unsubscribe send an email to users-leave@ovirt.org <mailto:users-leave@ovirt.org>