Bug 47365

Summary:	Include postgresql.conf.local in postgresql.conf
Product:	UCS	Reporter:	Michael Grandjean <grandjean>
Component:	PostgreSQL	Assignee:	UCS maintainers <ucs-maintainers>
Status:	NEW ---	QA Contact:	UCS maintainers <ucs-maintainers>
Severity:	normal
Priority:	P5	CC:	ahrnke, andree.hingst, requate, stephan.hendl, voelker
Version:	UCS 4.4
Target Milestone:	---
Hardware:	Other
OS:	other
See Also:	https://forge.univention.org/bugzilla/show_bug.cgi?id=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:

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.