vitabaks/postgresql_cluster 1.10.0

Release 1.10.0

on GitHub

New features

• Enhanced Multi-Data Center Traffic Management
  • Added capabilities for dynamic configuration of Patroni REST API endpoints with custom tags like datacenter=<name>, enabling optimized local load balancing and improved read efficiency across geographically distributed Postgres clusters.
    • Add the ability to set Patroni tags (including custom tags) by @vitabaks in #611
      • Variable: patroni_tags
    • Add the ability to set tags for HAProxy load balancers by @vitabaks in #613 #618
      • Variable: balancer_tags

Enhancements

• Adds variables to enable client tls on pgbouncer by @n-borges in #585
• update_pgcluster.yml improvements
  • Wait for caches to warm up after reboot by @vitabaks in #580
  • Use Patroni REST API instead of patronictl command to switchover by @SDV109 in #596
• pg_upgrade.yml improvements
  • Analyze a PostgreSQL database (optimizer statistics) immediately after the upgrade by @vitabaks in #601
  • Monitor and terminate the long-running transactions during statistics collection by @vitabaks in #601
    • optional, variable: vacuumdb_analyze_terminate_threshold
  • Upgrade and rollback Improvements by @vitabaks in #608
• Patroni: Add permanent replication slots by @vitabaks in #614
  • Variable: patroni_slots (by default, the value is not defined)
• Add patroni_restapi_listen_addr and postgresql_listen_addr variables by @vitabaks in #598

Fixes

• update_pgcluster.yml
  • Improve error handling by @vitabaks in #578
• pg_upgrade.yml
  • Apply timeout directly to psql in PgBouncer pause script by @vitabaks in #600
  • Make sure that the 'recovery.signal' file is absent by @vitabaks in #607

Other

• Python 3.11 use on RedHat 8 and above by @weisscorp in #573
• Update ansible dependencies and fix lister's warnings by @vitabaks in #579
• Replace the pg_ctlcluster command with pg_ctl and increase the timeout by @vitabaks in #590
• pgbackrest : Add pg1-socket-path option by @vitabaks in #606
• ansible_python_interpreter: Use Python 3 (by default) by @vitabaks in #624
• Update the tasks to check the availability of the VIP address by @vitabaks in #623
• Update Patroni to v3.3.0 by @vitabaks in #621
• Update WAL-G to v3.0.0 by @vitabaks in #629

Tests

• Molecule: Update all system packages before testing by @vitabaks in #575

New Contributors

• @weisscorp made their first contribution in #573
• @n-borges made their first contribution in #585

Full Changelog: 1.9.0...1.10.0