Re: Need inputs on postgresql HA with consul cluster

Hi Karthik,

This is docker based Postgtresql, behavior is different than our normal one for failover and promotion.

On Wed, Dec 20, 2023, 03:05 Karthik Yellapragada <karthik.yellapragada@gmail.com> wrote:

May be you can pg auto failover..

On Tue, Dec 19, 2023 at 9:33 AM Rambabu V <ram.wissen@gmail.com> wrote:

Thanks, any alternative solution for my requirement .

In above case if consul down , db master node going down, replica nodes remains recovery mode.its complete downtime.

On Tue, Dec 19, 2023, 22:23 Scott Ribe <scott_ribe@elevated-dev.com> wrote:

> On Dec 19, 2023, at 7:12 AM, Rambabu V <ram.wissen@gmail.com> wrote:
>
> Hi Team,
>
> We have implemented postgresql HA with Patroni + Consul cluster on Docker based PostgreSQL Setup.
>
> We are seeing the issue below.
>
> our consul cluster built with 3 nodes, if consul cluster completely down, Patroni triggering failover.
> Is there any option to prevent this failure even if the consul cluster is down also?
>
> and also any effective alternative for HA for docker based PostgreSQL setup?

How do you expect to have working HA without working networking?

--

Thanks & Regards
Karthik Yellapragada
+1 860 830 5235