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.
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.
The problem exists in 4.4 as well. Please change OS version to UCS 4.4.
This issue has been filed against an older version of UCS. With further development of our products affected components may have vastly changed while the corresponding use cases might have changed. Thus, this issue is now being closed. If there still is a need for this feature, please use "Clone this bug" or reopen this issue. In this case please provide information on how this issue would benefit you.