Re: Need inputs on postgresql HA with consul cluster

@Rambabu
You can try this: DCS Failsafe Mode
https://patroni.readthedocs.io/en/master/dcs_failsafe_mode.html#id2
https://speakerdeck.com/cyberdemn/failsafe-patroni-3-dot-0
br
Kaido

On Wed, 20 Dec 2023 at 19:42, kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com> wrote:

> 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
>>>
>>