From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
---|---|
To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Switchover |
Date: | 2024-01-02 15:41:15 |
Message-ID: | CAJk5AtZCQeLtNnFm50CZG9dcQJkQzBQoKPjRXfeEamMpjrLVQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Can I take a small downtime and stop all applications and switchover or
shall I simply switchover during low traffic time?
On Thu, 28 Dec 2023, 19:55 Scott Ribe, <scott_ribe(at)elevated-dev(dot)com> wrote:
> In my experience:
>
> - Patroni switchover happens in a few seconds
> - If you use pgbouncer, the client connections don't get dropped. A client
> that issues a query in that brief window will get an error.
> - If your clients have retry logic, your users will never notice the
> failover.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
> > On Dec 27, 2023, at 10:38 PM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
> >
> > Do I have to take a downtime of few mns and stop the applications and do
> a switchover?
> >
> > What happens internally when we use the command patronictl switchover?
> Just that the role is changed? Will it affect incoming connections?
> >
> > On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
> > Hi all,
> >
> >
> > Any idea what prerequisite I should follow before I use the command
> patronictl switchover?
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | pramod kg | 2024-01-02 15:49:45 | Re: PostgreSQL local connection is taking 4 seconds |
Previous Message | SOzcn | 2024-01-02 15:33:59 | Re: Vacuum |