Setting up External Postgres DB with high availability

[#1]

Hi,

We need to setup the extrenal postgres with high availability. Currently the Postgres is with Active passive mode. When any fail happened then we need to manually failover the server and change the configurations in portal.

I am expecting if we can use the load balancer ( single IP) for that or we need to go with HA Proxy for the same.

and how we can make Postgres as Active - Active in this case because we need to go with failover automatically not manual.

[#2]

Hello @Kamalindia,

You can setup Database HA using the below document:
https://www.cloudera.com/documentation/enterprise/latest/topics/admin_cm_ha_dbms.html

To understand the DB failover in detail, request you to refer here:
https://www.postgresql.org/docs/9.1/warm-standby-failover.html

Regards,
Tarun Jangid