Bug 1052713

Summary: [RFE] Need additional supported database deployment options for Satellite 6 installation: such as External Postgres (and Managed Postgres?)
Product: Red Hat Satellite Reporter: Mike McCune <mmccune>
Component: InstallationAssignee: Martin Bacovsky <mbacovsk>
Status: CLOSED ERRATA QA Contact: Ales Dujicek <adujicek>
Severity: high Docs Contact:
Priority: high    
Version: 6.0.4CC: ahumbe, bkearney, byodlows, cwelton, dgross, dmoessne, egolov, ehelms, fgarciad, inecas, kabbott, kshirsal, mbacovsk, mjs, mkearey, mmccune, mmurray, mosvald, mrichter, nsalemme, pdwyer, pgervase, riehecky, rjerrido, saikiranrgda, satellite6-bugs, sellis, sghai, smane, sokeeffe, stbenjam, unwosu, vgunasek
Target Milestone: 6.4.0Keywords: FutureFeature, PrioBumpPM, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-10-16 15:25: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: 1563211    
Bug Blocks: 260381, 1052712, 1115190    

Description Mike McCune 2014-01-13 22:15:33 UTC
The Foreman installer has an option to specify the remote database host where postgres (or others) live:


--foreman-db-host

we need this to also be used when configuring the database the Katello engine uses as well as Candlepin.

This will allow us to support a database server that isn't the same machine as the Satellite 6 instance.

Comment 2 Xixi 2014-07-24 16:44:59 UTC
(In reply to Mike McCune from comment #0)
> The Foreman installer has an option to specify the remote database host
> where postgres (or others) live:
> 

Hi Mike, just to clarify/follow up from IRC, is this BZ only for external Postgres DB - or Managed Postgres and External Oracle as well (i.e. all options currently offered as of Satellite 5.6 [1])?

There's been questions from support about customers who're on Satellite 5.6 with external dbs (Postgres or Oracle) about how to transition while keeping their db setup.

Thanks,
Xixi

[1] https://access.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.6/html-single/Installation_Guide/index.html#sect-Installation_Guide-Hardware_Requirements

Comment 11 Bryan Kearney 2016-04-29 12:04:58 UTC
*** Bug 1331533 has been marked as a duplicate of this bug. ***

Comment 12 Sai Kiran Kanuri 2016-05-03 10:19:16 UTC
Please also do add gutterball to the list of DB's that need to have support to be on external DB's.

Comment 16 Bryan Kearney 2016-05-27 18:42:26 UTC
*** Bug 1338977 has been marked as a duplicate of this bug. ***

Comment 30 Martin Bacovsky 2017-05-25 09:29:54 UTC
Created redmine issue http://projects.theforeman.org/issues/19667 from this bug

Comment 36 Satellite Program 2017-08-08 22:02:05 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/19667 has been resolved.

Comment 37 Martin Bacovsky 2017-08-09 12:23:59 UTC
Moving back to Assigned due to some pending work on backup & restore.

Comment 38 Satellite Program 2017-08-09 14:01:56 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/19667 has been resolved.

Comment 39 Martin Bacovsky 2017-08-10 16:34:11 UTC
Adding upstream issue for tracking progress on support for remote db in backup and restore scripts

Comment 45 Satellite Program 2018-04-20 16:01:43 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20550 has been resolved.

Comment 48 Satellite Program 2018-04-26 12:01:49 UTC
Upstream bug assigned to jomitsch

Comment 53 Satellite Program 2018-05-18 10:01:45 UTC
Upstream bug assigned to mbacovsk

Comment 54 Satellite Program 2018-05-18 10:01:57 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/19667 has been resolved.

Comment 55 Rich Jerrido 2018-08-16 15:40:02 UTC
Updating $SUBJECT to be clear to what is being delivered. Satellite will ship with support for an external PostgreSQL database. 

Support for Oracle databases are NOT planned for a near-term release of Satellite 6.

Comment 59 errata-xmlrpc 2018-10-16 15:25:56 UTC
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-2018:2927