PostgreSQL14 HA with Patroni 2.1, Etcd, Haproxy, Keepalived (EL8)

Patroni is a cluster manager tool used for customizing and automating deployment and maintenance of high availability PostgreSQL clusters. 
In addition, Patroni is capable of handling database replication, backup, and restoration configurations.
In this blog I deploy PostgreSQL for High Availability (HA) and show how it works during a master failure.

01. software installation and environment configuration

• 01.01. Install PostgreSQL on pgsql-db01,pgsql-db02
• 01.02. Creation STANDBY database on pgsql-db02
• 01.03. Installation Etcd service on app-etcd
• 01.04. Installation Patroni on pgsql-db02
• 01.05. Instalation Patroni on pgsql-db01 and Startup Patroni
• 01.06. Database management with Patroni (manual switchover)
• 01.07. Installation Haproxy and Keepalived on app-haproxy01
• 01.08. Installation Haproxy and Keepalived on app-haproxy02

02. Failure testing

• 02.01. Simulation of failure of the MASTER node