May be you can pg auto failover..
On Tue, Dec 19, 2023 at 9:33 AM Rambabu V <ram.wissen@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> wrote:> On Dec 19, 2023, at 7:12 AM, Rambabu V <ram.wissen@xxxxxxxxx> 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
Karthik Yellapragada
+1 860 830 5235
