vitabaks/postgresql_cluster 1.5.0

Release 1.5.0

on GitHub

New features

• Custom WAL location ("postgresql_wal_dir" variable) (ac3850d)
• Allow conversion of the basic primary-standby replication to the patroni cluster (1b5516e)
• Compatibility with Oracle Linux 7 and 8.

Enhancements

• Add "disable_archive_command" and "keep_patroni_dynamic_json" variables (61bf839)
• patroni: add log settings (4172977)
• wal-g (custom bootstrap): Wait for PostgreSQL Recovery to complete (WAL apply) (a374b8d)
• Allow execution of the "generate pg_hba.conf on Replica" task for RedHat-based systems, if the "postgresql_exists" variable is "true" (a7f683b)
• Allow to perform pg_hba tasks before executing the add_pgnode.yml playbook for cluster scaling:
  ansible-playbook deploy_pgcluster.yml --tags pg_hba (a7f683b)
• Add "haproxy_maxconn" and "haproxy_timeout" variables (1f0ac50, f190881)
• add sysctl parameter "net.ipv4.tcp_tw_reuse" (5046b77)
• Add --wait and --timeout options for pg_ctl stop command (923c776)
• Add Development repository for OracleLinux 7 (6463894)
• Reinstall glibc-common to avoid problem when generating locales (for OracleLinux 7) (5837ae4)
• pgbackrest: install gnupg and apt-transport-https packages (323ab6e)
• etcd: set "initial-selection-tick-advance=false" (0f651c7)
• etcd role: Make sure the unzip/tar packages are present (dd5ee62)
• etcd_ver: "v3.3.25" (dc49266)
• wal_g_ver: "v0.2.19" (1b37807)
• postgresql: 13 (by default) (7b301b9)

Fixes

• Don't generate pg_hba.conf on every PITR (3952a49)
• add extra_opts: --no-same-owner for unarchive module (f21316c)
• Restrict standard local port range (9bfb151)
• fix issue with "is search" condition for ansible older then 2.9 (54ed666)
• do not generate pg_hba.conf on replica if postgresql_conf_dir=postgresql_data_dir (3128767)
• check that the /etc/locale.conf exists (2575ed1)
• Use ansible_python_interpreter: /usr/bin/python3 for pip3 tasks (f14191a)

Other

• comment out the example nameservers (88337b4)
• ansible: disable deprecation_warnings (06fb7af)
• Update requirements.txt (ff3e01e)
• remove wal_e vars (f546561)
• Add meta/main.yml (c52b46c)
• Upgrade urllib3 to version 1.25.9 or later (e55d295)

Tests

• molecule: add nameservers to converge.yml (a581b49)
• Add molecule test for Oracle Linux 7 and 8 (e7af72a, df59d7e)
• Update ansible-lint.yml (support for multiple versions of ansible) (fb6574c, c768be6, 5aca26c, 6803bc9, 5e1dcea)

EOL

• Delete Ubuntu 16.04 from the list of supported OS (75afbc2)