Bug 1165776

Summary:	Satellite 6 installs postgres with default configuration
Product:	Red Hat Satellite	Reporter:	Alex Krzos <akrzos>
Component:	Installation	Assignee:	Ewoud Kohl van Wijngaarden <ekohlvan>
Status:	CLOSED ERRATA	QA Contact:	Peter Ondrejka <pondrejk>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.0.4	CC:	bbuckingham, bkearney, ehelms, greartes, perfbz, riehecky, stbenjam
Target Milestone:	6.4.0	Keywords:	Reopened, Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-10-16 19:04:38 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:

Description Alex Krzos 2014-11-19 16:43:10 UTC

Description of problem:

Installed Satellite 6 on RHEL 6.5 and RHEL 7 and the postgres configuration is set to the default settings.  Ex shared_buffers is 32MB and recommendation from postgres documentation is 25% of available RAM.  Since Satellite 6 houses two databases with different workloads in postgres (foreman and candlepin) we need to assess configuration changes that best support performance for both databases.

This BZ is to track any suggested configuration changes to postgres for satellite 6.

Comment 1 RHEL Program Management 2014-11-19 16:53:50 UTC

Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

Comment 3 Bryan Kearney 2016-07-08 20:30:01 UTC

Per 6.3 planning, moving out non acked bugs to the backlog

Comment 5 Stephen Benjamin 2016-10-14 13:12:53 UTC

Created redmine issue http://projects.theforeman.org/issues/16932 from this bug

Comment 6 Bryan Kearney 2017-08-01 20:34:23 UTC

Thank you for your interest in Satellite 6. We have evaluated this request, and we do not expect this to be implemented in product in the foreseeable future. We are therefore closing this out as WONTFIX. If you have any concerns about this, please feel free to contact Rich Jerrido or Bryan Kearney. Thank you.

Comment 7 Bryan Kearney 2018-05-03 14:32:41 UTC

Reopening.

Comment 8 Satellite Program 2018-05-03 14:37:43 UTC

Upstream bug assigned to ekohlvan

Comment 9 Satellite Program 2018-05-03 14:37:46 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/16932 has been resolved.

Comment 11 Peter Ondrejka 2018-06-11 14:43:26 UTC

Verified using psql on Sat 6.4 snap 7

Comment 12 Bryan Kearney 2018-10-16 19:04:38 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