Bug 1162737

Summary: Installer --clear-db does not correctly default to postgres 92 if old postgres is installed
Product: Red Hat Satellite 5 Reporter: Stephen Herr <sherr>
Component: InstallerAssignee: Tomáš Kašpárek <tkasparek>
Status: CLOSED DEFERRED QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 570CC: tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-04-09 11:33:56 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: 1162131    

Description Stephen Herr 2014-11-11 15:29:53 UTC 
Description of problem:
I'm trying to re-install Sat 5.7 on a machine that was originally an upgrade from Sat 5.6 (so postgresql 8 is installed).

Actual results:
# ./install.pl --clear-db
* Starting Red Hat Satellite installer.
* Performing pre-install checks.
* Pre-install checks complete.  Beginning installation.
* RHN Registration.
** Registration: System is already registered with RHN.  Not re-registering.
* Checking for uninstalled prerequisites.
* Installing RHN packages.
* Now running spacewalk-setup.
* Setting up SELinux..
** Database: Setting up database connection for PostgreSQL backend.
** Database: Embedded database installation SKIPPED.
** Database: Populating database.
** Database: --clear-db option used.  Clearing database.
** Database: Shutting down spacewalk services that may be using DB.
** Database: Services stopped.  Clearing DB.
*** Progress: #
Could not populate database.

Investigation reveals that the "postgresql" service was running, not "postgresql92-postgresql" as expected. If I:
service postgresql stop
rm -rf /opt/rh/postgresql92/root/var/lib/pgsql/data
service postgresql92-postgresql initd
service postgresql92-postgresql start

then the install (without --clear-db) can proceed as normal.
Comment 2 Tomas Lestach 2018-04-09 11:33:56 UTC 
We have re-reviewed this bug, as part of an ongoing effort to improve Satellite/Proxy feature and bug updates, review and backlog.

This is a low priority bug and has no currently open customer cases. While this bug may still valid, we do not see it being implemented prior to the EOL of the Satellite 5.x product. As such, this is being CLOSED DEFERRED. 

Closing now to help set customer expectations as early as possible. You are welcome to re-open this bug if needed.