Support for Patroni High Availability

Products

• VMware Tanzu for Postgres

Issue/Introduction

Do you support Patroni as a high availability (HA) solution for VMware Postgres?

Resolution

VMware Postgres supports two High Availability (HA) solutions, one of which is Patroni, Starting with version 11.5, Patroni is shipped as part of the Postgres binary.

Patroni acts as a template that allows you to create a customized high-availability solution using Python and etcd (a Distributed Consensus Store).

You can also use Patroni to configure a standby cluster on a Disaster Recovery (DR) site that steams from the primary site. The standby cluster receives Write Ahead Log (WAL) records via streaming replication and you can promote it to primary during a failover event.

VMware Postgres High Availability with Patroni

Configuration Steps

1. Verify Binary: Ensure you are running VMware Postgres 11.5 or higher to have Patroni included.
2. Setup etcd: Configure a distributed consensus store using etcd to provide a decision-making mechanism for leader election.
3. Configure YAML: Update your Patroni configureation files (e.g., postgres.yml) on each host with the appropriate IP addresses and cluster scope.
4. Initialize Cluster: Start the Patroni process or initialize the database and acquire the leader lock.

For detailed implementation steps regarding DR sites, refer to the documentation on Configure Disaster Recovery with Patroni.