Bug 1434418 – Upgrade PostgreSQL to 9.5

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1434418 - Upgrade PostgreSQL to 9.5

Summary:	Upgrade PostgreSQL to 9.5

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Satellite 5
Classification:	Red Hat
Component:	Upgrades (Show other bugs)
Sub Component:
Version:	570
Hardware:	Unspecified Unspecified

Priority	unspecified Severity unspecified
Target Milestone:	---
Target Release:	---
Assigned To:	Tomáš Kašpárek
QA Contact:	Ales Dujicek
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:	sat5-rhn
	Show dependency tree / graph

Reported:	2017-03-21 09:20 EDT by Tomáš Kašpárek
Modified:	2017-08-07 12:12 EDT (History)
CC List:	4 users (show)

See Also:	1434446
Fixed In Version:
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2017-08-07 12:12:04 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHSA-2017:2425	normal	SHIPPED_LIVE	Moderate: rh-postgresql95-postgresql security update	2017-08-07 16:11:22 EDT

Groups: None (edit)

Description Tomáš Kašpárek 2017-03-21 09:20:38 EDT

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 10:16:53 EDT

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 10:24:06 EDT

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 03:04:14 EDT

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 10:44:26 EDT

Bug 1477245 also applies here

Comment 19 errata-xmlrpc 2017-08-07 12:12:04 EDT

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

Note You need to log in before you can comment on or make changes to this bug.