High Availability Configuration

To set up the high availability environment, it is necessary to first configure the DCS, then the Agent on the Master and, soon after, the Agent on each replica of the environment. Check out the commands required to configure high availability in the PostgreSQL Ecosystem in detail below:

High Availability Components Configuration

DCS Configuration: Distributed Configuration Repository

Configure the DCS (etcd) so that High Availability Agents can reliably and consistently share configuration and state information.

High Availability Agent Configuration

Configure the High Availability Agent (Patroni) for automation and orchestration of database clusters.

High Availability Proxy Configuration

Configure the High Availability proxy (HAProxy) to recognize and direct connections to the master instance.

High Availability Parameters Configuration

DCS Parameter Configuration: Distributed Configuration Store.

Configure the parameters of the DCS - Distributed Configuration Store (etcd).

High Availability Agent Parameter Configuration

Configure the parameters of the High Availability Agent (Patroni).

High Availability Proxy Parameter Configuration

Configure the parameters of the High Availability Proxy (HAProxy).