Bug 1334351

Summary: Broken in-place upgrade from rh-postgresql94-postgresql
Product: Red Hat Software Collections Reporter: Pavel Raiskup <praiskup>
Component: rh-postgresql95Assignee: Pavel Kajaba <pkajaba>
Status: CLOSED ERRATA QA Contact: Jakub Prokes <jprokes>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: rh-postgresql95CC: databases-maint, hhorak, jorton, jpopelka, jprokes, kanderso, pkajaba, praiskup
Target Milestone: rc   
Target Release: 2.2   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-05-31 10:23:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Proposed fix. none

Description Pavel Raiskup 2016-05-09 12:26:38 UTC
The IDs of previous clusters should be named like %{scl}-postgresql, similarly
to how the default service files are named.  So the
/etc/opt/rh/rh-postgresql95/postgresql-setup/upgrade/scl-postgresql94.conf
should have 'id' like 'rh-postgresql94-postgresql', not postgresql94-postgresql.

Also, the default data directory of rh-postgresql94 is
/var/opt/rh/rh-postgresql94/lib/pgsql/data, not
/opt/rh/postgresql94/root/var/lib/pgsql/data

Comment 1 Pavel Raiskup 2016-05-09 12:34:00 UTC
And the bin directory of 9.4 cluster is
/opt/rh/rh-postgresql94/root/usr/bin
instead of
/opt/rh/postgresql94/root/usr/bin.

The patch should look like:

-id             rh-postgresql94-postgresql
+id             postgresql94-postgresql
 major          9.4
-data_default   /var/opt/rh/rh-postgresql94/lib/pgsql/data
-engine         /opt/rh/rh-postgresql94/root/usr/bin
+data_default   /opt/rh/postgresql94/root/var/lib/pgsql/data
+engine         /opt/rh/postgresql94/root/usr/bin
 description    "Upgrade data from RHSCL 2.X PostgreSQL version (PostgreSQL 9.4)"
 scls           "postgresql94"
 redhat_sockets_hack yes

Comment 2 Pavel Raiskup 2016-05-09 12:39:50 UTC
Ah, this is correct:

-id             postgresql94-postgresql
+id             rh-postgresql94-postgresql
 major          9.4
-data_default   /opt/rh/postgresql94/root/var/lib/pgsql/data
-engine         /opt/rh/postgresql94/root/usr/bin
+data_default   /var/opt/rh/rh-postgresql94/lib/pgsql/data
+engine         /opt/rh/rh-postgresql94/root/usr/bin
 description    "Upgrade data from RHSCL 2.X PostgreSQL version (PostgreSQL 9.4)"
-scls           "postgresql94"
+scls           "rh-postgresql94"
 redhat_sockets_hack yes

Comment 3 Pavel Raiskup 2016-05-09 12:43:05 UTC
Created attachment 1155309 [details]
Proposed fix.

Comment 9 errata-xmlrpc 2016-05-31 10:23: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-2016:1165