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 https://github.com/vitabaks/postgresql_cluster/pull/611
      • Variable: patroni_tags
    • Add the ability to set tags for HAProxy load balancers by @vitabaks in https://github.com/vitabaks/postgresql_cluster/pull/613 https://github.com/vitabaks/postgresql_cluster/pull/618
      • Variable: balancer_tags

Enhancements

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

Fixes

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

Other

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

Tests

• Molecule: Update all system packages before testing by @vitabaks in https://github.com/vitabaks/postgresql_cluster/pull/575

New Contributors

• @weisscorp made their first contribution in https://github.com/vitabaks/postgresql_cluster/pull/573
• @n-borges made their first contribution in https://github.com/vitabaks/postgresql_cluster/pull/585

Full Changelog: https://github.com/vitabaks/postgresql_cluster/compare/1.9.0...1.10.0