------=_Part_20349653_1465707940.1519829079176 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit If I run # engine-backup --mode=restore --file=back_futur --log=log_futur --provision-db --restore-permissions --provision-dwh-db --log=/root/rest-log to create a log, I found these errors: 2018-02-28 14:36:31 6339: pg_cmd running: psql -w -U ovirt_engine_history -h localhost -p 5432 ovirt_engine_history -t -c show lc_messages 2018-02-28 14:36:31 6339: pg_cmd running: pg_dump -w -U ovirt_engine_history -h localhost -p 5432 ovirt_engine_history -s 2018-02-28 14:36:31 6339: OUTPUT: - Engine database 'engine' 2018-02-28 14:36:31 6339: Restoring engine database backup at /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db 2018-02-28 14:36:31 6339: restoreDB: backupfile /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db user engine host localhost port 5432 database engine orig_user compressor format custom jobsnum 2 2018-02-28 14:36:31 6339: pg_cmd running: pg_restore -w -U engine -h localhost -p 5432 -d engine -j 2 /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 7314; 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'; pg_restore: [archiver (db)] Error from TOC entry 693; 1255 211334 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; pg_restore: WARNING: column "user_role_title" has type "unknown" DETAIL: Proceeding with relation creation anyway. pg_restore: WARNING: no privileges could be revoked for "public" pg_restore: WARNING: no privileges could be revoked for "public" pg_restore: WARNING: no privileges were granted for "public" pg_restore: WARNING: no privileges were granted for "public" WARNING: errors ignored on restore: 3 2018-02-28 14:37:23 6339: FATAL: Errors while restoring database engine De: suporte@logicworks.pt Para: "Yedidyah Bar David" <didi@redhat.com> Cc: "ovirt users" <users@ovirt.org> Enviadas: Quarta-feira, 28 De Fevereiro de 2018 12:45:04 Assunto: Re: [ovirt-users] Backup & Restore Still no luck: # engine-backup --mode=restore --file=back_futur --log=log_futur --provision-db --restore-permissions --provision-dwh-db Preparing to restore: - Unpacking file 'back_futur' Restoring: - Files Provisioning PostgreSQL users/databases: - user 'engine', database 'engine' - user 'ovirt_engine_history', database 'ovirt_engine_history' Restoring: - Engine database 'engine' FATAL: Errors while restoring database engine I did a engine-cleanup, try it again but still the same error. De: "Yedidyah Bar David" <didi@redhat.com> Para: suporte@logicworks.pt Cc: "ovirt users" <users@ovirt.org> Enviadas: Quarta-feira, 28 De Fevereiro de 2018 12:24:50 Assunto: Re: [ovirt-users] Backup & Restore On Wed, Feb 28, 2018 at 2:10 PM, <suporte@logicworks.pt> wrote:
Hi,
I'm testing backup & restore on Ovirt 4.2. I follow this doc https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/ Try to restore to a fresh installation but always get this error message:
restore-permissions Preparing to restore: - Unpacking file 'back_file' Restoring: - Files Provisioning PostgreSQL users/databases: - user 'engine', database 'engine' Restoring: FATAL: Can't connect to database 'ovirt_engine_history'. Please see '/usr/bin/engine-backup --help'.
On the live engine I run # engine-backup --scope=all --mode=backup --file=file_name --log=log_file_name
And try to restore on a fresh installation: # engine-backup --mode=restore --file=file_name --log=log_file_name --provision-db --restore-permissions
Any Idea?
</div><div># engine-backup --mode=3Drestore --file=3Dback_futur --log=3Dlo= g_futur --provision-db --restore-permissions --provision-dwh-db --log=3D/ro= ot/rest-log</div><div><br data-mce-bogus=3D"1"></div><div>to create a log, = I found these errors:<br data-mce-bogus=3D"1"></div><div><br data-mce-bogus= =3D"1"></div><div>2018-02-28 14:36:31 6339: pg_cmd running: psql -w -U ovir= t_engine_history -h localhost -p 5432 ovirt_engine_history -t -c show lc_me= ssages<br>2018-02-28 14:36:31 6339: pg_cmd running: pg_dump -w -U ovirt_eng= ine_history -h localhost -p 5432 ovirt_engine_history -s<br>2018-02-28 14:3= 6:31 6339: OUTPUT: - Engine database 'engine'<br>2018-02-28 14:36:31 6339: = Restoring engine database backup at /tmp/engine-backup.VVkcNuYAkV/db/engine= _backup.db<br>2018-02-28 14:36:31 6339: restoreDB: backupfile /tmp/engine-b= ackup.VVkcNuYAkV/db/engine_backup.db user engine host localhost port 5432 d= atabase engine orig_user compressor format custom jobsnum 2<br>2018-02-28 1= 4:36:31 6339: pg_cmd running: pg_restore -w -U engine -h localhost -p 5432 = -d engine -j 2 /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db<br>pg_rest= ore: [archiver (db)] Error while PROCESSING TOC:<br>pg_restore: [archiver (= db)] Error from TOC entry 7314; 0 0 COMMENT EXTENSION plpgsql <br>pg_restor= e: [archiver (db)] could not execute query: ERROR: must be owner of extensi= on plpgsql<br> Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL proce= dural language';<br><br><br><br>pg_restore: [archiver (db)] Error from TOC = entry 693; 1255 211334 FUNCTION uuid_generate_v1() engine<br>pg_restore: [a= rchiver (db)] could not execute query: ERROR: function "uuid_generate_v1" a= lready exists with same argument types<br> Command was: CREATE FUNCTION uui= d_generate_v1() RETURNS uuid<br> LANGUAGE plpgsql STABLE<br> AS '<br>DECLAR= E<br> v_val BIGINT;<br> v_4_1_par...<br>pg_restore: [archiver (db)] could n= ot execute query: ERROR: must be owner of function uuid_generate_v1<br> Com= mand was: ALTER FUNCTION public.uuid_generate_v1() OWNER TO engine;<br><br>= <br>pg_restore: WARNING: column "user_role_title" has type "unknown"<br>DET= AIL: Proceeding with relation creation anyway.<br>pg_restore: WARNING: no p= rivileges could be revoked for "public"<br>pg_restore: WARNING: no privileg= es could be revoked for "public"<br>pg_restore: WARNING: no privileges were= granted for "public"<br>pg_restore: WARNING: no privileges were granted fo= r "public"<br>WARNING: errors ignored on restore: 3<br>2018-02-28 14:37:23 = 6339: FATAL: Errors while restoring database engine<br></div><div><br></div= <hr id=3D"zwchr" data-marker=3D"__DIVIDER__"><div data-marker=3D"__HEADERS= __"><b>De: </b>suporte@logicworks.pt<br><b>Para: </b>"Yedidyah Bar David" &= lt;didi@redhat.com><br><b>Cc: </b>"ovirt users" <users@ovirt.org><= br><b>Enviadas: </b>Quarta-feira, 28 De Fevereiro de 2018 12:45:04<br><b>As= sunto: </b>Re: [ovirt-users] Backup & Restore<br></div><br><div data-ma= rker=3D"__QUOTED_TEXT__"><div style=3D"font-family: trebuchet ms,sans-serif= ; font-size: 12pt; color: #000000"><div>Still no luck:<br></div><br><div># = engine-backup --mode=3Drestore --file=3Dback_futur --log=3Dlog_futur --prov= ision-db --restore-permissions --provision-dwh-db<br>Preparing to restore:<= br>- Unpacking file 'back_futur'<br>Restoring:<br>- Files<br>Provisioning P= ostgreSQL users/databases:<br>- user 'engine', database 'engine'<br>- user = 'ovirt_engine_history', database 'ovirt_engine_history'<br>Restoring:<br>- = Engine database 'engine'<br>FATAL: Errors while restoring database engine<b= r></div><br><div>I did a engine-cleanup, try it again but still the same er= ror.<br></div><br><hr id=3D"zwchr"><div><b>De: </b>"Yedidyah Bar David" <= ;didi@redhat.com><br><b>Para: </b>suporte@logicworks.pt<br><b>Cc: </b>"o= virt users" <users@ovirt.org><br><b>Enviadas: </b>Quarta-feira, 28 De= Fevereiro de 2018 12:24:50<br><b>Assunto: </b>Re: [ovirt-users] Backup &am=
Please try adding to restore command '--providion-dwh-db'. Thanks. -- Didi _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ------=_Part_20349653_1465707940.1519829079176 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: trebuchet ms,sans-serif; font-size: = 12pt; color: #000000"><div>If I run <br></div><div><br data-mce-bogus=3D"1"= p; Restore<br></div><br><div>On Wed, Feb 28, 2018 at 2:10 PM, <sup= orte@logicworks.pt> wrote:<br>> Hi,<br>><br>> I'm testing backu= p & restore on Ovirt 4.2.<br>> I follow this doc<br>> https://www= .ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/<br>> Tr= y to restore to a fresh installation but always get this error message:<br>= ><br>> restore-permissions<br>> Preparing to restore:<br>> - Un= packing file 'back_file'<br>> Restoring:<br>> - Files<br>> Provisi= oning PostgreSQL users/databases:<br>> - user 'engine', database 'engine= '<br>> Restoring:<br>> FATAL: Can't connect to database 'ovirt_engine= _history'. Please see<br>> '/usr/bin/engine-backup --help'.<br>><br>&= gt; On the live engine I run # engine-backup --scope=3Dall --mode=3Dbackup<= br>> --file=3Dfile_name --log=3Dlog_file_name<br>><br>> And try to= restore on a fresh installation:<br>> # engine-backup --mode=3Drestore = --file=3Dfile_name --log=3Dlog_file_name<br>> --provision-db --restore-p= ermissions<br>><br>> Any Idea?<br><br>Please try adding to restore co= mmand '--providion-dwh-db'. Thanks.<br>-- <br>Didi<br></div></div><br>_____= __________________________________________<br>Users mailing list<br>Users@o= virt.org<br>http://lists.ovirt.org/mailman/listinfo/users<br></div></div></= body></html> ------=_Part_20349653_1465707940.1519829079176--