Yedidyah Bar David has posted comments on this change.

Change subject: packaging: engine-backup: Fix changing owner
......................................................................


Patch Set 2: Verified+1

Verified by:

engine-setup - setup engine/dwh/reports

engine-backup --mode=backup --log=b1.log --file=b1

engine-cleanup

service postgresql stop

rm -rf /var/lib/pgsql/data

service postgresql initdb

edited /var/lib/pgsql/data/pg_hba.conf and added after the 'local' line:

 host    all         all         127.0.0.1/32          md5
 host    all         all         ::1/128               md5

service postgresql restart

In psql as postgres:

create user enginec password 'enginec3';

create database enginec owner enginec template template0 encoding 'UTF8' 
lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';

create user enginecdwh password 'enginecdwh3';

create database enginecdwh owner enginecdwh template template0 encoding 'UTF8' 
lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';

create role enginecrep with login encrypted password 'enginecrep3';

create database enginecrep template template0 encoding 'UTF8' lc_collate 
'en_US.UTF-8' lc_ctype 'en_US.UTF-8' owner enginecrep;

Restore:

engine-backup --mode=restore --file=b1 --log=b1-restore1.log 
--change-db-credentials --db-host=localhost --db-user=enginec 
--db-password=enginec3 --db-name=enginec --change-dwh-db-credentials 
--dwh-db-host=localhost --dwh-db-user=enginecdwh --dwh-db-password=enginecdwh3 
--dwh-db-name=enginecdwh --change-reports-db-credentials 
--reports-db-host=localhost --reports-db-user=enginecrep 
--reports-db-password=enginecrep3 --reports-db-name=enginecrep

Connected to enginec using psql and ran (see [1]):

UPDATE dwh_history_timekeeping SET var_value=0 WHERE var_name 
='DwhCurrentlyRunning';

engine-setup

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1158985#c3

-- 
To view, visit http://gerrit.ovirt.org/36150
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: comment
Gerrit-Change-Id: Ifc864805217cbd30b3c3b97f3be342825edc98f7
Gerrit-PatchSet: 2
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Yedidyah Bar David <[email protected]>
Gerrit-Reviewer: Eli Mesika <[email protected]>
Gerrit-Reviewer: Lev Veyde <[email protected]>
Gerrit-Reviewer: Sandro Bonazzola <[email protected]>
Gerrit-Reviewer: Simone Tiraboschi <[email protected]>
Gerrit-Reviewer: Yedidyah Bar David <[email protected]>
Gerrit-Reviewer: [email protected]
Gerrit-Reviewer: oVirt Jenkins CI Server
Gerrit-HasComments: No
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to