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