Bug 1434418

Summary:	Upgrade PostgreSQL to 9.5
Product:	Red Hat Satellite 5	Reporter:	Tomáš Kašpárek <tkasparek>
Component:	Upgrades	Assignee:	Tomáš Kašpárek <tkasparek>
Status:	CLOSED ERRATA	QA Contact:	Ales Dujicek <adujicek>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	570	CC:	adujicek, ggainey, lhellebr, tlestach
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-08-07 16:12:04 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:
Bug Depends On:
Bug Blocks:	1391420

Description Tomáš Kašpárek 2017-03-21 13:20:38 UTC

Description of problem:
PostgreSQL 9.2 is EOL we need to upgrade PostgreSQL to 9.5.

Version-Release number of selected component (if applicable):
Satellite 5.7

Actual results:
Unsupported version of PostgreSQL is present.

Expected results:
PostgreSQL is upgraded to 9.5.

Additional info:
spacewalk-upgrade-postgresql can be backported to 5.7 - tested it and it works.

Comment 6 Lukáš Hellebrandt 2017-07-13 14:16:53 UTC

FailsQA because:

1) After spacewalk-upgrade-postgresql, the config file /usr/share/rhn/config-defaults/rhn_dobby.conf is not updated -> db-control {start,stop} do not work

2) After spacewalk-upgrade-postgresql, ManageDB is not running while EmbeddedDB is

3) On a self-registered Satellite, spacewalk-upgrade-postgresql shuts the Satellite down then runs a yum command against it, resulting in:
[...]
Loaded plugins: rhnplugin
There was an error communicating with RHN.
RHN channel support will be disabled.
rhn-plugin: Error communicating with server. The message was:
Internal Server Error
Setting up Remove Process
[...]


At least 1) is a blocker.

Comment 7 Lukáš Hellebrandt 2017-07-13 14:24:06 UTC

4) Package rh-postgresql95 is in the erratum but is not installed by update (rh-postgresql95 is installed for dependency). Everything works without this package but if we do not want it installed, it should not be in the erratum.

Comment 8 Tomáš Kašpárek 2017-07-17 07:04:14 UTC

1 - the erratum is missing several changes needed for spacewalk-dobby, spacewalk-debug and spacewalk-hostname-rename to work, will add this

2 - minor change, will fix

3 - will investigate

4 - will remove

Comment 15 Lukáš Hellebrandt 2017-08-01 14:44:26 UTC

Bug 1477245 also applies here

Comment 19 errata-xmlrpc 2017-08-07 16:12:04 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/RHSA-2017:2425