Bug 1405977 - Upgrade 5.6 RHEL5 emb to 5.8 RHEL6 emb: Convert PostgreSQL data to new format step
Summary: Upgrade 5.6 RHEL5 emb to 5.8 RHEL6 emb: Convert PostgreSQL data to new format...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 580
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Ales Dujicek
URL:
Whiteboard:
Depends On:
Blocks: sat580-upgrades
TreeView+ depends on / blocked
 
Reported: 2016-12-19 12:03 UTC by Ales Dujicek
Modified: 2017-06-21 12:05 UTC (History)
2 users (show)

Fixed In Version: spacewalk-setup-postgresql-2.5.0-14-sat
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-06-21 12:05:49 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

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
Note You need to log in before you can comment on or make changes to this bug.