Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.300.61.1.2\))
Subject: Re: Switchover
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAJk5AtZao0MEHVj-3yKwK-JJNoBd8YsU9qG0Kix-o0+EBRPq1A@mail.gmail.com>
Date: Thu, 28 Dec 2023 07:25:20 -0700
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <D1AA6686-E36E-40AD-9CAD-91FF59814349@elevated-dev.com>
References: 
 <CAJk5AtanGhcNyMuSmr3hQ5b-mDDyqido-=vcD5MKeFPew2g+Cw@mail.gmail.com>
 <CAJk5AtZao0MEHVj-3yKwK-JJNoBd8YsU9qG0Kix-o0+EBRPq1A@mail.gmail.com>
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/D1AA6686-E36E-40AD-9CAD-91FF59814349%40elevated-dev.com>
Precedence: bulk

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@elevated-dev.com
https://www.linkedin.com/in/scottribe/


> On Dec 27, 2023, at 10:38=E2=80=AFPM, Rajesh Kumar =
<rajeshkumar.dba09@gmail.com> wrote:
>=20
> Do I have to take a downtime of few mns and stop the applications and =
do a switchover?
>=20
> What happens internally when we use the command patronictl switchover? =
Just that the role is changed? Will it affect incoming connections?
>=20
> On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> =
wrote:
> Hi all,
>=20
>=20
> Any idea what prerequisite I should follow before I use the command =
patronictl switchover?