From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
---|---|
To: | scott_ribe(at)elevated-dev(dot)com |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Client not able to pick up |
Date: | 2024-07-03 18:49:22 |
Message-ID: | CAJk5Ata67c667yNA8bU1-cYWvd5kr0Bx2rz+VHmExRuXUHwXnw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Patronictl and etcd is not enough for autofailover right....there must be
HAproxy setup
On Thu, 4 Jul 2024, 00:13 Scott Ribe, <scott_ribe(at)elevated-dev(dot)com> wrote:
> How are you using HAProxy??? PostgreSQL can only have one master taking
> writes. So if you're sending write transactions to HAProxy to split among
> master & replicas, then yeah, there's your problem.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
> > On Jul 3, 2024, at 11:27 AM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
> >
> > Can this problem due to issues with HAproxy?
> >
> > On Tue, 2 Jul 2024, 19:22 Scott Ribe, <scott_ribe(at)elevated-dev(dot)com>
> wrote:
> > > On Jul 2, 2024, at 7:25 AM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
> > >
> > > Let's ignore pgbouncer. I am getting the same error for client who are
> connected directly
> >
> > Principle is the same, something is setting the read only state.
> >
> > - Either the database is read only, as for a hot standby for instance;
> > - Or the user is set to default to read only;
> > - Or the client is setting read only and not subsequently setting read
> write.
> >
> > Ignoring pg bouncer just means excluding the possibility that the read
> only state was set by some client other than the one reporting the error.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Wetmore, Matthew (CTR) | 2024-07-03 18:53:09 | RE: [EXTERNAL] Re: Client not able to pick up |
Previous Message | Scott Ribe | 2024-07-03 18:42:55 | Re: Client not able to pick up |