New features

• Automate database backup: create crontab for pgbackrest (https://github.com/vitabaks/postgresql_cluster/pull/215 thanks @chlordk)
• Add PostgreSQL schemas. New variable: postgresql_schemas (https://github.com/vitabaks/postgresql_cluster/pull/187 thanks @chlordk)
• Add playbook remove_cluster.yml (https://github.com/vitabaks/postgresql_cluster/pull/188, https://github.com/vitabaks/postgresql_cluster/pull/189 thanks @chlordk)

Enhancements

• pgbouncer: new variable: ignore_startup_parameters (https://github.com/vitabaks/postgresql_cluster/pull/163 thanks @jimnydev)
• pgbouncer: new variables: pgbouncer_admin_users, pgbouncer_stats_users (23565bddfb70c6c92ea90d30c6940327be4f1521)
• Restart Patroni service if it crashed (b56d50439f5e0d9621667a9495288711790ded93)
• Add compatibility with ubuntu 22.04 (44aeb5d968254d36748e3235f22277dad6e2c1ff)

Fixes

• Support different patroni_superuser_username (271a357317b1b2f1d147bea76ced751b5dc9aea2, 83a2f3ec2de5e5cdca80a6ca1729fa375e47bb59)
• Role postgresql-users: add "postgres" as the default database to connect (0752de87b26462edc5d19a09437880b0705abbff)
• Role sysctl: improve sysctl_conf_dynamic_var variable (issue #211, MR #214 thanks @linuxfreakus)

Other

• Gathering Facts from all servers, tags: always (6daa87575427ff35f965c91d0d777cfa21a44b06)
• Do not configure firewall (iptables) by default (aee256219ee1f7a2299228833ce2619261646862)
• Do not generate the locale "ru_RU" by default (09c9b6fa628833a62e2f687b9b0180396d2bf2bb)
• PostgreSQL: increase the max_worker_processes parameter (6027669716867462936e70ae51432ebf674bec19)
• PostgreSQL: add auto_explain.sample_rate parameter (584e8076a5a35b94bc5157a97d7eaa01392e1917)
• Comment out the "net.netfilter.nf_conntrack_max" kernel parameter (a911cb56c6680c25b7b0cc2c08033ccacb4b6a07)
• Comment out the "kernel.sched_migration_cost_ns" kernel parameter (bf3fd8432e5f011a62eeed3f04dfd334e0de7ff2)
• README: Index - Table Of Content (https://github.com/vitabaks/postgresql_cluster/pull/190 thanks @chlordk)
• README: Make image path relative (https://github.com/vitabaks/postgresql_cluster/pull/198 thanks @chlordk)

Tests

• Molecule: add tests on ubuntu 22.04 (b93386fd42969a4ffa8659f453a385bbd48af636)
• Update ansible-lint.yml (333249d1eae118c499b4d2dbeb8a9ed346ab2854, eeca5a5560748d69b4967ba5030b55a87e712df4, f0b77e70956fb1fd5055cd8188dcb0fdc2a1726b, ea506330cd4d5ef322f05deaaf9eaba0c0f43a39, c8ed863c7ab26508f09958e9c7c80cf62293914b)
• Update molecule.yml (061d13dd05f3f23248873df47f30bb7b189375b1 , e05b5daa8c8a82a652d35250dbd3bc4b98c96034 , b5ab21677faf0854ae68bed6773cb3ce25cecade)

Comparing changes: https://github.com/vitabaks/postgresql_cluster/compare/1.6.0...1.6.1