Bug 1440879 - [RFE] postgres configurations need to be included in variables on Satellite Server in /var/lib/pgsql/data/postgresql.conf and these should be available for customization.
Summary: [RFE] postgres configurations need to be included in variables on Satellite S...
Keywords:
Status: CLOSED DUPLICATE of bug 1312098
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Installation
Version: 6.2.8
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: Katello QA List
URL:
Whiteboard:
: 1312680 1449707 (view as bug list)
Depends On:
Blocks: 1312098
TreeView+ depends on / blocked
 
Reported: 2017-04-10 16:26 UTC by Giridhar
Modified: 2023-10-06 17:36 UTC (History)
13 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-06-28 10:57:42 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SAT-6957 0 None None None 2021-12-10 15:25:55 UTC

Comment 1 Stephen Benjamin 2017-05-10 13:37:12 UTC
*** Bug 1449707 has been marked as a duplicate of this bug. ***

Comment 3 Stephen Benjamin 2017-05-10 13:39:49 UTC
There are various variables which are not included in  /var/lib/pgsql/data/postgresql.conf and thus need to add below listed variable at the location in order to address the issues which the Cu faces while running satellite-installer.Is there any way to incorporate the required settings in /var/lib/pgsql/data/postgresql.conf somewhere in the Satellite ?

work_mem = 4MB
shared_buffers = 256MB
max_connections = 500

so satellite-installer will generate the correct /var/lib/pgsql/data/postgresql.conf file when it is run again.
   
https://access.redhat.com/articles/2951701 includes limited examples for the persistent tuning.  However, I lack the expertise to determine how to add the large system tunings from https://access.redhat.com/documentation/en-us/red_hat_satellite/6.2/html/installation_guide/large_deployment_considerations to the persistent settings.

Comment 4 Amar Huchchanavar 2017-07-03 17:14:46 UTC
I have customer who would like to make below changes persistent.

>> postgresql.conf :
 
ssl = on
ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'

>>pg_hba.conf :

hostssl all postgres 127.0.0.1/32 cert clientcert=1
hostssl all all 127.0.0.1/32 cert clientcert=1
hostssl all all ::1/128 cert clientcert=1

Comment 5 Stephen Benjamin 2018-04-26 14:37:48 UTC
It looks like this was handled as part of https://bugzilla.redhat.com/show_bug.cgi?id=1312098, upstream now has the support for persisting these changes to the Postgres configuration.  It should end up in a future version of Satellite.

*** This bug has been marked as a duplicate of bug 1312098 ***

Comment 11 Ewoud Kohl van Wijngaarden 2018-06-22 09:42:32 UTC
*** Bug 1312680 has been marked as a duplicate of this bug. ***

Comment 14 Julio Entrena Perez 2018-06-28 10:57:42 UTC

*** This bug has been marked as a duplicate of bug 1312098 ***


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