| From: | Karthik Yellapragada <karthik(dot)yellapragada(at)gmail(dot)com> |
|---|---|
| To: | Rambabu V <ram(dot)wissen(at)gmail(dot)com> |
| Cc: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Need inputs on postgresql HA with consul cluster |
| Date: | 2023-12-19 19:05:10 |
| Message-ID: | CACXtxt9RF84_hR0=RSUOxQ4snNU_2NeqUYw=UwC4OZTtpNa-Nw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murthy Nunna | 2023-12-19 23:08:04 | Timestamps in outputs |
| Previous Message | Ron Johnson | 2023-12-19 17:40:04 | Re: Need inputs on postgresql HA with consul cluster |