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.
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.
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.
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
Bug 1477245 also applies here
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