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(a)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_Resto... <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Resto... 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(a)ovirt.org <mailto:users@ovirt.org> To unsubscribe send an email to users-leave(a)ovirt.org <mailto:users-leave@ovirt.org>

Hi, according to the logs it seems that something was already in the engine DB. Could you please try running engine-cleanup before trying the restore? On Thu, May 24, 2018 at 3:24 PM, thetas emmanuel <emmanuel.thetas(a)obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote: hi, see my restore.log in attachment regards, -- Emmanuel Thétas Equipe informatique support_informatique AT obs-nancay.fr <http://obs-nancay.fr> Station de Radio-astronomie de Nançay (USN/Observatoire de Paris/CNRS) 18330 Nançay mail: emmanuel.thetas AT obs-nancay.fr <http://obs-nancay.fr> tel: 02 48 51 87 20 fax: 02 48 51 83 18 web: http://www.obs-nancay.fr 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(a)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_Resto... > <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Resto... > > 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(a)ovirt.org <mailto:users@ovirt.org> > To unsubscribe send an email to users-leave(a)ovirt.org > <mailto:users-leave@ovirt.org> > >

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(a)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_Resto... <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Resto... 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(a)ovirt.org <mailto:users@ovirt.org> To unsubscribe send an email to users-leave(a)ovirt.org <mailto:users-leave@ovirt.org>

for info: if i use pg_restore with file extract from backup scl enable rh-postgresql95 'pg_restore -d engine /root/db/engine_backup.db' no error!! same think with ovirt_engine_history -- 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(a)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_Resto... > <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Resto... > > 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(a)ovirt.org <mailto:users@ovirt.org> > To unsubscribe send an email to users-leave(a)ovirt.org > <mailto:users-leave@ovirt.org> > > _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/OR55P3N3YIW...