Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Setting up External Postgres DB with high availability

Setting up External Postgres DB with high availability

Explorer

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.

 

 

1 REPLY 1
Highlighted

Re: Setting up External Postgres DB with high availability

Cloudera Employee
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
Don't have an account?
Coming from Hortonworks? Activate your account here