Bug 1405977

Summary:	Upgrade 5.6 RHEL5 emb to 5.8 RHEL6 emb: Convert PostgreSQL data to new format step
Product:	Red Hat Satellite 5	Reporter:	Ales Dujicek <adujicek>
Component:	Upgrades	Assignee:	Tomáš Kašpárek <tkasparek>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Ales Dujicek <adujicek>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	580	CC:	galtukho, tlestach
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	spacewalk-setup-postgresql-2.5.0-14-sat	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-06-21 12:05:49 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:	1393921

Description Ales Dujicek 2016-12-19 12:03:15 UTC

Description of problem:

Convert PostgreSQL data to new format step fails
in upgrade Sat 5.6 with emb database on RHEL5 to Sat 5.8 emb database on RHEL6.

# db-control restore /root/db-backup/
...
Removing unnecessary files... done.
Restoring empty directories... done.
Restoration complete, you may now start the database.

# /usr/bin/spacewalk-upgrade-postgresql
start: unrecognized service


Version-Release number of selected component (if applicable):
spacewalk-setup-postgresql-2.5.0-13.el6sat.noarch

Comment 1 Ales Dujicek 2017-01-09 08:22:11 UTC

The same problem is in Managed DB and system upgrade path.
If 5.8 installer installs new postgres and you import old postgres dump then 
/usr/bin/spacewalk-upgrade-postgresql miss postgresql-server (quite obviously..)

The solution is to install postgresql-server and continue with upgrade.
It can be fixed in rhn-upgrade docs.

rhn-upgrade-5.8.0.7-1.el5sat