vitabaks/postgresql_cluster v1.3.0

Release 1.3.0

on GitHub

New features

• Added WAL-G support (#32 thanks Anton Patsev @patsevanton )
  Now you can deploy PostgreSQL high availability clusters as well as create replicas from wal-g backups.
  If variable wal_g_install is true, wal-g will be installed and the necessary parameters will be specified in the walg.json conf file in postgresql_home_dir, and patroni.yml will be prepared for using wal-g.
  See the variables:
  patroni_cluster_bootstrap_method
patroni_create_replica_methods
postgresql_restore_command
wal_g_install, wal_g_ver, wal_g_json

• Added compatibility with Ubuntu 20.04 LTS (#35).

Enhancements

• VIP: make the cluster ip address as optional (176a36a, 6d9b0fc).
  Now you can deploy your custom schemes without using a cluster IP address (VIP) if necessary.
• postgresql: update to version 12 (by default) (a6a2ab0)
• etcd: update to version 3.3.19 (by default) (1ec3fff).
• etcd: added compatibility with etcd version 3.4.x (1b05ba5)
• haproxy: update to version 1.8.25 for haproxy_installation_method: "src" (a28d08e).
• pgbouncer: disable log_connections and log_disconnections (b5e29a3).
• pgbouncer: auto-recovery of crashed pgbouncer.service with systemd (3444c3f).
• pgbouncer: increase listen_backlog to 4096 (2545b54).
• sysctl: add net backlog kernel parameters (567ebda).
• Added "python-consul" module in requirements. For support the "Consul" DCS (6391cfb).
• Code Refactoring (#33, #34)

Fixes

• vip-manager: create a conf directory if it does not exist (7079672).
• specify "-U postgres" for the "get postgresql database list" task (ad5e21d).
• сheck if postgresql packages are installed for postgresql_exists: "true" (a226a20).
• remove python2 package (no more required for pgbouncer) for RHEL/CentOS 8 (62282eb).
• remove example ip address from cluster_vip (a36e4dd).
• fixed yamllint and ansible-lint warnings/errors.

Tests

• Added ansible-lint and yamllint GitHub Actions workflow for linting playbooks.