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.