Feature #7611
openScript for modification of postgresql.conf for only necessary changes
0%
Description
On regular update of PostgreSQL we have to incorporate config file changes again and again and again. This is quite time consuming and error prone as postgresql.conf changes practically always and sometimes quite substantially. Some script, which updates just "our" values in default conf (to keep conf file up to date with PostgreSQL version) would be nice.
Related issues
Updated by Rajmund Hruška 16 days ago
- Related to Bug #7807: Timeline queries are not shown in My queries added
Updated by Rajmund Hruška 16 days ago
We could enhance the existing mentat-postgresql role in Padrino. It would have a dictionary of the values we want to change and using the lineinfile module we could replace them in the default configuration. When upgrading PostgreSQL, we could just increase the version and it would create a new cluster with the desired configuration. We could then just take the configuration and drop the cluster.
Also, this role could have a tag, so we can choose to run only this role in the playbook.