How to Set Up a highly Available PostgreSQL Cluster using (Patroni, etcd, HAProxy) on CentOS7, RHEL7

This video tutorial will help you to set up a highly available PostgreSQL cluster on CentOS7, RHEL 7.
Written instruction available at: www.techsuppor...
#highavailability #postgresql #patroni #haproxy

[@onikazadovi8745]

I have followd your tutorial step by step but facing this erro "psql: error: could not connect to server: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?"

[@techsupportpk]

This happens due to firewall blocking postgresql port by default. You can allow access to port 5432 from firewall like below:
sudo firewall-cmd --zone=public --add-port=5432/tcp --permanent

[@rakeshb2010]

Hey wonderful video. Subscribed. Can you pls let me know if Python 3.6 need to be installed on Centos 7? I am getting error when starting patroni.. "File... init.py.. line 89 in get dcs". Any idea? Thanks

[@techsupportpk]

When you install patroni, all the required dependencies will automatically be installed...You do not need to install python 3.6 additionally...Follow the step by step instruction to correct your errors www.techsupportpk.com/2020/02/how-to-create-highly-available-postgresql-cluster-using-patroni-haproxy-centos-rhel-7.html

[@rakeshb2010]

@@techsupportpk thank you. Will try again.

[@techsupportpk]

Wish you success!

[@rakeshb2010]

@@techsupportpk hi one question, can we choose which node to become master after failover? For example: if u have three nodes. Two in one datacenter, i want the second one to become master not the node in other datacenter. Thanks.