Use PostgreSQL's default values to override Patroni dynamic config

DJ Mountneyrequested to merge
patroni-max-connections into master

What does this MR do?

Uses PostgreSQL's settings for the following attributes to set postgresql parameters in Patroni's dynamic settings:

  • max_connections
  • max_locks_per_transaction
  • max_worker_processes

These parameters are controlled via the dynamic config when using Patroni: https://patroni.readthedocs.io/en/latest/dynamic_configuration.html

It also detects the value of wal_log_hints (when not specified in PostgreSQL overrides) based on patroni['use_pg_rewind'].

Related issues

Fixes: #5741 (closed)

Also related to: #5746 (closed) (configuring PostgreSQL for pg_rewind)

Checklist

See Definition of done.

For anything in this list which will not be completed, please provide a reason in the MR discussion

Required

  • Merge Request Title, and Description are up to date, accurate, and descriptive
  • MR targeting the appropriate branch
  • MR has a green pipeline on GitLab.com
  • Pipeline is green on dev.gitlab.org if the change is touching anything besides documentation or internal cookbooks
  • trigger-package has a green pipeline running against latest commit

Expected (please provide an explanation if not completing)

  • Test plan indicating conditions for success has been posted and passes
  • Documentation created/updated
  • Tests added
  • Integration tests added to GitLab QA
  • Equivalent MR/issue for the GitLab Chart opened
Edited by DJ Mountney

Merge request reports