MIME-Version: 1.0
References: <CAAu_hGv-gMAqC71JrcooYpX1-e3PNe6hCuxHox1SEzgAwz2HMg@mail.gmail.com>
In-Reply-To: <CAAu_hGv-gMAqC71JrcooYpX1-e3PNe6hCuxHox1SEzgAwz2HMg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 19 Jun 2024 13:07:56 -0400
Message-ID: <CANzqJaDi+Jb6tA+cx2Z-NMcLXVS_ZLr-7OSq3QLQmATC9_r1YA@mail.gmail.com>
Subject: Re: Manual Failover
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000072873061b413ef6"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDi%2BJb6tA%2Bcx2Z-NMcLXVS_ZLr-7OSq3QLQmATC9_r1YA%40mail.gmail.com>
Precedence: bulk

--000000000000072873061b413ef6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Jun 19, 2024 at 11:03=E2=80=AFAM Yongye Serkfem <yserkfem@gmail.com=
> wrote:

> Hello Engineers,
> I am facing an issue with the manual failover of the standby to the maste=
r
> role. I was able to promote the standby and got it out of recovery mode.
> How do I direct applications to point to the standby which has assumed th=
e
> role of the current master,
>

A typical solution is a separate service which manages a virtual IP that
points to whichever DB server you choose.


> and what should I do after completing maintenance on the previous master
> to assume its original role as master?
>

pg_basebackup is guaranteed to get previous-master in sync with
now-active.  pg_rewind might also work.

--000000000000072873061b413ef6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Jun 19, 2024 at 11:03=E2=80=AFAM =
Yongye Serkfem &lt;<a href=3D"mailto:yserkfem@gmail.com">yserkfem@gmail.com=
</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div dir=3D"ltr">Hello Engineers,<div>I am facin=
g an issue with the manual failover of the standby to the master role. I wa=
s able to promote the standby and got it out of recovery=C2=A0mode. How do =
I direct applications to point to the standby which has assumed the role of=
 the current master,</div></div></blockquote><div><br></div><div><div>A typ=
ical solution is a separate service which manages a virtual IP that points =
to whichever DB server you choose.</div><div>=C2=A0<br></div></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div> and what s=
hould I do after completing maintenance on the previous=C2=A0master to assu=
me its original role as master?=C2=A0</div></div></blockquote><div><br></di=
v><div>pg_basebackup is guaranteed to get previous-master=C2=A0in sync with=
 now-active.=C2=A0 pg_rewind might also work.</div><div><br></div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex">
</blockquote></div></div>

--000000000000072873061b413ef6--