Bug 1826789

Summary: [TESTONLY] Verify upgrade from SCL PostgreSQL 10.6 to SCL PostgreSQL 10.12
Product: Red Hat Enterprise Virtualization Manager Reporter: Martin Perina <mperina>
Component: ovirt-engineAssignee: Eli Mesika <emesika>
Status: CLOSED ERRATA QA Contact: Lucie Leistnerova <lleistne>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 4.3.10CC: lsvaty, nlevy, pelauter, rdlugyhe
Target Milestone: ovirt-4.3.10Keywords: Rebase, ZStream
Target Release: 4.3.10   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-06-04 15:04:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Martin Perina 2020-04-22 14:52:55 UTC 
As a part of automatic upgrade from RH SCL 3.2 to RH SCL 3.4 PostgreSQL 10 will receive an upgrade from 10.6 to 10.12.

So we need to verify all upgrade scenarios (local & remote engine & DWH database) to see if there are any manual steps needed (which we would need to document) or everything is automatic and just RPM upgrade is enough. 

This is 4.3.z only change.
Comment 1 Eli Mesika 2020-04-22 17:01:11 UTC 
upgrade SCL 10.6 to SCL 10.12 
=================================


****************************************************************
Tested with 1 NFS master SD / 1 running host/ 
1 running VM with 1 Disk and 1 Nic
****************************************************************

For local engine/dwh , all you have to do
=========================================

1) yum install -y centos-release-scl-rh
2) yum --enablerepo=centos-sclo-rh-testing install rh-postgresql10-postgresql-server
3) scl enable rh-postgresql10 bash
4) engine-setup

After engine-setup completes, the engine was running with SD/Host/VM as before the upgrade.

For remote engine/DWH
======================

****************************************************************
Tested with backup/restore mode when backup is done with PG 10.6 
and restore is done on PG 10.12 using engine-backup
****************************************************************

This also worked smoothly without any problems, engine after restore followed by engine-setup runs with SD/Host/VM as before the restore.

The upgrade from PG 10.6 to 10.12 is safe and basically is only a RPM upgrade
Comment 2 RHV bug bot 2020-04-24 12:45:09 UTC 
WARN: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[Found non-acked flags: '{'rhevm-4.3.z': '?'}', ]

For more info please contact: rhv-devops: Bug status wasn't changed from MODIFIED to ON_QA due to the following reason:

[Found non-acked flags: '{'rhevm-4.3.z': '?'}', ]

For more info please contact: rhv-devops
Comment 6 Lucie Leistnerova 2020-05-21 10:39:08 UTC 
local engine&dwh db - OK
remote engine&dwh db - just update postgres packages, OK

No additional manual steps needed, verified in updating ovirt-engine-4.3.9.4-11.el7.noarch -> ovirt-engine-4.3.10.3-0.1.master.el7.noarch
Comment 8 errata-xmlrpc 2020-06-04 15:04:01 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2020:2396