pg_auto_failover_ansible
pg_auto_failover_ansible copied to clipboard
Ansible Playbook(s) to create/manage a cluster of PostgreSQL nodes running in a cluster with pg_auto_failover
… and 16 All tests run properly in Ubuntu 20.04 and 22.04. Several other changes were implemented. Including full support of scram-sha-256 for Postgres and pgbouncer. All code has been...
This project currently somewhat has a hard requirement for Ansible 2.8.5 because we have not tested it with anything else. We should add support for newer Ansible versions. This should...
https://github.com/citusdata/pg_auto_failover/issues/868#issuecomment-1165482754 It looks like pg_auto_failover moved to apt.postgresql.org
https://pg-auto-failover.readthedocs.io/en/latest/operations.html#monitoring-pg-auto-failover-in-production
https://github.com/CrunchyData/pgmonitor
We need a role to automatically setup pgbouncer so we can have many more connections.
we default to require ssl certs so there is no immediate risk, but maybe we should use scram-sha by default for pgbouncer and postgres so that the on disk/in db...