Bug 1440879
| Summary: | [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. | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Giridhar <gkonda> |
| Component: | Installation | Assignee: | satellite6-bugs <satellite6-bugs> |
| Status: | CLOSED DUPLICATE | QA Contact: | Katello QA List <katello-qa-list> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.2.8 | CC: | ahuchcha, aperotti, bkearney, ehelms, ekohlvan, fgarciad, folajimi, jcallaha, jentrena, mvanderw, psuriset, riehecky, stbenjam |
| Target Milestone: | Unspecified | Keywords: | FutureFeature, Reopened, Triaged |
| Target Release: | Unused | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-06-28 10:57:42 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: | 1312098 | ||
|
Comment 1
Stephen Benjamin
2017-05-10 13:37:12 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. 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 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 *** *** Bug 1312680 has been marked as a duplicate of this bug. *** *** This bug has been marked as a duplicate of bug 1312098 *** |