Bug 47365 – Include postgresql.conf.local in postgresql.conf

Bug 47365 - Include postgresql.conf.local in postgresql.conf


Summary:	Include postgresql.conf.local in postgresql.conf

Status:	NEW

Product:	UCS
Classification:	Unclassified
Component:	PostgreSQL
Version:	UCS 4.4
Hardware:	Other other

Importance:	P5 normal with 4 votes (vote)
Target Milestone:	---
Assigned To:	UCS maintainers
QA Contact:	UCS maintainers

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-07-17 11:37 CEST by Michael Grandjean
Modified:	2020-09-10 15:49 CEST (History)
CC List:	5 users (show)

See Also:	47276
What kind of report is it?:	Feature Request
What type of bug is this?:	---
Who will be affected by this bug?:	---
How will those affected feel about the bug?:	---
User Pain:
Enterprise Customer affected?:	Yes
School Customer affected?:	Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:	2018100921000179
Bug group (optional):
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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

Description Michael Grandjean

2018-07-17 11:37:26 CEST

We should offer to include a postgresql.conf.local in postgresql.conf. PostgreSQL is capable of doing this:
https://www.postgresql.org/docs/9.6/static/config-setting.html

This way customers could optimize their PostgreSQL config (e.g via pgtune) without modifying the UCR template.

Comment 1 Christian Völker

2018-10-09 17:22:42 CEST

Requested as a customer changed its postgreSQL for better performance.

Changes will get lost with next update. 

Default postgresql.conf is generated by template and it reads:
#------------------------------------------------------------------------------
# CONFIG FILE INCLUDES
#------------------------------------------------------------------------------

# These options allow settings to be loaded from files other than the
# default postgresql.conf.

#include_dir = 'conf.d'                 # include files ending in '.conf' from
                                        # directory 'conf.d'
#include_if_exists = 'exists.conf'      # include file only if it exists
#include = 'special.conf'               # include file


We should change the template so it activates the line "include_dir" and create the conf.d so customers can apply their own settings. Thus, all is update-safe.

Comment 2 Stephan Hendl 2020-07-06 08:25:13 CEST

The problem exists in 4.4 as well. Please change OS version to UCS 4.4.