From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
---|---|
To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Switchover |
Date: | 2023-12-28 14:25:20 |
Message-ID: | D1AA6686-E36E-40AD-9CAD-91FF59814349@elevated-dev.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Wilson, Maria Louise (LARC-E301)[RSES] | 2023-12-28 16:00:43 | Re: [EXTERNAL] Re: Need help with slow query - postgres 12 on linux RHEL 8 |
Previous Message | kaido vaikla | 2023-12-28 13:10:28 | Re: Switchover |