Re: Need inputs on postgresql HA with consul cluster

Consul is DCS for patroni. If consul cluster is completely down, then
patroni is unaware of state of cluster.
And "In above case if consul down , db master node going down, replica
nodes remains recovery mode"
is expected. Actually this behave protects database from split brain

br
Kaido

On Wed, 20 Dec 2023 at 03:52, Rambabu V <ram(dot)wissen(at)gmail(dot)com> wrote:

> 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(dot)yellapragada(at)gmail(dot)com> wrote:
>
>> May be you can pg auto failover..
>>
>> On Tue, Dec 19, 2023 at 9:33 AM Rambabu V <ram(dot)wissen(at)gmail(dot)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(at)elevated-dev(dot)com>
>>> wrote:
>>>
>>>> > On Dec 19, 2023, at 7:12 AM, Rambabu V <ram(dot)wissen(at)gmail(dot)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
>>
>