vitabaks/postgresql_cluster 1.7.0

Release 1.7.0

on GitHub

New features

• Support Consul for distributed consensus (#238)
  • New type of scheme: [Type C] PostgreSQL High-Availability with Consul Service Discovery (DNS)
• Added the ability to manage configuration parameters for a deployed Patroni cluster (#218 thanks @artemsafiyulin)
  • Playbook: config_pgcluster.yml
  • Can be used for integration with Git for cluster configuration management (infrastructure as code)
  • For example: GitHub Action (link), GitLab CI/CD (link)

Enhancements

• Added the ability to install new versions of WAL-G. Update to version 2.0.1 (#226)
• Added compatibility with the Red Hat family version 9 (5eb45fc)
• Make sure that the total size of the pgbouncer pools does not exceed max_connections (#237, thanks @artemsafiyulin)

Fixes

• Fix yamllint warnings (e005628)
• Compatibility with python 3.6 for the task "install pip" (7c152f6)
• postgresql_parameters: fix log_filename parameter (#230)
• Role confd: fixe URL to the etcd cluster nodes (for dcs_exists: true) (#231)
• Role hostname: change hostname in /etc/hosts for localhost only (42840a2)
• Fix /etc/environment error for variable PATRONICTL_CONFIG_FILE (#242, thanks @anyuta1166)
• Fix typo in confd role (#243, thanks @anyuta1166)
• Pin setuptools package to version <66 (#244)

Other

• Update firewall_ports_dynamic_var, firewall_rules_dynamic_var (a6c7d40)
• packages: change state from latest to present (3c9429d)
• Added pipelining mode to Ansible configuration (20dad13)
• Remove the "warn: false" argument for the command module for compatibility with Ansible version 7 (b4e1c86).
• Update requirements.txt (switch to boto3 and add pysyncobj module) (f2f70f9)
• Add tag "install_packages" for the task of installing postgresql packages (af1dc80)
• pgbouncer: update the path to the pid file (4f1d890)
• haproxy: update the path to the pid file (cedd92b)
• Remove compatibility with Debian 9 Stretch (1e26921)
• PostgreSQL 15 (by default) (b71473c)

Tests

• Add .yamllint file (4ed1f6e)
• Update .ansible-lint (14a1927)
• Molecule: add cgroupns_mode to fix CI workflow (42b56fd)
• Molecule: remove CentOS 7 and Oracle Linux 7 from tests (844baf4)
• Add CentOS Stream 8 and 9, Rocky Linux 9, AlmaLinux 9, Oracle Linux 9 to tests (d9cdfc9, e731b19)
• Remove "curl" from the "system_packages" list to prevent failures in CI (9e91e4b)

Comparing changes: 1.6.1...1.7.0