[ovirt-users] Backup & Restore

[suporte at logicworks.pt]

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 at logicworks.pt 
Para: "Yedidyah Bar David" <didi at redhat.com> 
Cc: "ovirt users" <users at 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 at redhat.com> 
Para: suporte at logicworks.pt 
Cc: "ovirt users" <users at 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 at 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? 

Please try adding to restore command '--providion-dwh-db'. Thanks. 
-- 
Didi 

_______________________________________________ 
Users mailing list 
Users at ovirt.org 
http://lists.ovirt.org/mailman/listinfo/users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180228/32af9c73/attachment.html>