Re: Need inputs on postgresql HA with consul cluster

From: Rambabu V <ram(dot)wissen(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Need inputs on postgresql HA with consul cluster
Date: 2023-12-19 17:32:35
Message-ID: CADtiZxr-VsW+7ZTFh9V6p_k08G2DV6fn_o3YR46gY=wGcRAVRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2023-12-19 17:40:04 Re: Need inputs on postgresql HA with consul cluster
Previous Message SOzcn 2023-12-19 16:33:49 Re: Would-be standby-node phoning home every 5 seconds. Why?