MIME-Version: 1.0
References: 
 <CA+-Cqf6b2FY3nJuOL==XsUyVqSev47gXR57u8t5z2LfNZSLAaA@mail.gmail.com>
In-Reply-To: 
 <CA+-Cqf6b2FY3nJuOL==XsUyVqSev47gXR57u8t5z2LfNZSLAaA@mail.gmail.com>
From: sethu mathavan <sethumathavan1612@gmail.com>
Date: Thu, 19 Sep 2024 17:05:06 +0530
Message-ID: 
 <CAO9pKO1-P1JRqs_0UpEGYiur7cMUev4zvbJqKqNV391VNFPP3A@mail.gmail.com>
Subject: Re: Failover and Failback
To: "Narendran .j" <jnarendran3@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003fdde10622775171"
Archived-At: 
 <https://www.postgresql.org/message-id/CAO9pKO1-P1JRqs_0UpEGYiur7cMUev4zvbJqKqNV391VNFPP3A%40mail.gmail.com>
Precedence: bulk

--0000000000003fdde10622775171
Content-Type: text/plain; charset="UTF-8"

Hi Narendran,

Before running rewind command,need to change few parameters in
postgresql.conf file.like primary_conninfo in old_master.

Regards,
Sethu

On Thu, 19 Sep, 2024, 4:46 pm Narendran .j, <jnarendran3@gmail.com> wrote:

> Hello Team,
>
> I have facing a problem in failback. I just promoted my secondary as
> master by using pg_ctl promote.it was successful.so now how can I bring
> my old master as primary I tried with pg_rewind it's not working. So is
> there any other way to perform failback. Is there any procedure to perform
> failback and failover please share with me. Additionally we don't use any
> tool for it.
>
> Regards
> Narendran J
>

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

<p dir=3D"ltr">Hi Narendran,</p>
<p dir=3D"ltr">Before running rewind command,need to change few parameters =
in postgresql.conf file.like primary_conninfo in old_master.</p>
<p dir=3D"ltr">Regards,<br>
Sethu</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu=
, 19 Sep, 2024, 4:46 pm Narendran .j, &lt;<a href=3D"mailto:jnarendran3@gma=
il.com">jnarendran3@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"auto">Hello Team,<div dir=3D"auto"><br></div><div dir=
=3D"auto">I have facing a problem in failback. I just promoted my secondary=
 as master by using pg_ctl <a href=3D"http://promote.it" target=3D"_blank" =
rel=3D"noreferrer">promote.it</a> was successful.so now how can I bring my =
old master as primary I tried with pg_rewind it&#39;s not=C2=A0working. So =
is there any other way to perform failback. Is there any procedure to perfo=
rm failback and failover please share with me. Additionally we don&#39;t us=
e any tool for it.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Regar=
ds=C2=A0</div><div dir=3D"auto">Narendran J</div></div>
</blockquote></div>

--0000000000003fdde10622775171--