Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1052713 - [RFE] Need additional supported database deployment options for Satellite 6 installation: such as External Postgres (and Managed Postgres?)
[RFE] Need additional supported database deployment options for Satellite 6 i...
Status: CLOSED ERRATA
Product: Red Hat Satellite 6
Classification: Red Hat
Component: Installer (Show other bugs)
6.0.4
Unspecified Unspecified
high Severity high (vote)
: Unspecified
: Unused
Assigned To: Martin Bacovsky
Ales Dujicek
: FutureFeature, PrioBumpPM, Triaged
: 1331533 1338977 (view as bug list)
Depends On: 1563211
Blocks: GSS_Sat6Beta_Tracker/GSS_Sat6_Tracker 260381 1052712
  Show dependency treegraph
 
Reported: 2014-01-13 17:15 EST by Mike McCune
Modified: 2018-10-16 11:27 EDT (History)
33 users (show)

See Also:
Fixed In Version:
Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2018-10-16 11:25:56 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 2139431 None None None 2016-05-04 02:24 EDT
Foreman Issue Tracker 19667 None None None 2017-05-25 05:30 EDT
Foreman Issue Tracker 20550 None None None 2017-08-10 12:32 EDT
Foreman Issue Tracker 22886 None None None 2018-04-26 06:11 EDT
Red Hat Product Errata RHSA-2018:2927 None None None 2018-10-16 11:27 EDT

  None (edit)
Description Mike McCune 2014-01-13 17:15:33 EST
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 12:44:59 EDT
(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 08:04:58 EDT
*** Bug 1331533 has been marked as a duplicate of this bug. ***
Comment 12 Sai Kiran Kanuri 2016-05-03 06:19:16 EDT
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 14:42:26 EDT
*** Bug 1338977 has been marked as a duplicate of this bug. ***
Comment 30 Martin Bacovsky 2017-05-25 05:29:54 EDT
Created redmine issue http://projects.theforeman.org/issues/19667 from this bug
Comment 36 pm-sat@redhat.com 2017-08-08 18:02:05 EDT
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 08:23:59 EDT
Moving back to Assigned due to some pending work on backup & restore.
Comment 38 pm-sat@redhat.com 2017-08-09 10:01:56 EDT
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 12:34:11 EDT
Adding upstream issue for tracking progress on support for remote db in backup and restore scripts
Comment 45 pm-sat@redhat.com 2018-04-20 12:01:43 EDT
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 pm-sat@redhat.com 2018-04-26 08:01:49 EDT
Upstream bug assigned to jomitsch@redhat.com
Comment 53 pm-sat@redhat.com 2018-05-18 06:01:45 EDT
Upstream bug assigned to mbacovsk@redhat.com
Comment 54 pm-sat@redhat.com 2018-05-18 06:01:57 EDT
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 11:40:02 EDT
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 11:25:56 EDT
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

Note You need to log in before you can comment on or make changes to this bug.