MIME-Version: 1.0
References: 
 <CAFPcKG0p8MORbc+AVuSxc9shW7HqcEnQiE5hsk-f-y+cey5Txg@mail.gmail.com>
In-Reply-To: 
 <CAFPcKG0p8MORbc+AVuSxc9shW7HqcEnQiE5hsk-f-y+cey5Txg@mail.gmail.com>
From: SOzcn <selahattinozcnma@gmail.com>
Date: Fri, 22 Nov 2024 19:27:18 +0300
Message-ID: 
 <CAJyV5AZCqoHe2qG2ZZbNNY-_i7E_dSQAPzsHK6zAoi=9fb0Xbg@mail.gmail.com>
Subject: Re: DB Switch over and Switch back support
To: jayakumar s <kumardba27.postgresql@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f64b95062782db42"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJyV5AZCqoHe2qG2ZZbNNY-_i7E_dSQAPzsHK6zAoi%3D9fb0Xbg%40mail.gmail.com>
Precedence: bulk

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

Hello,

If you did this with the replication method physically it's not possible.
You can manage it with Crontab on the OS.

As an example ;
Switchover 1  from node 1 to node 2.
- Make failover on your replica.   sudo pg_ctlcluster 14 main promote
Switchover 2 :
On node 1 clear your data path and make a new replica from node 2 to node 1
then make failover again.

You can prepare the steps and manage them with Crontab or some bash script.
Bash script might work better for this I think.

It could work mostly with less data-sizing environments. If you have a load
environment I would advice you to patroni cluster system.

Have a nice weekend.

jayakumar s <kumardba27.postgresql@gmail.com>, 22 Kas 2024 Cum, 18:59
tarihinde =C5=9Funu yazd=C4=B1:

> Hi Team,
>
> I have configured master and slave DB's. Need to configure switcher and
> switch back setup. I checked google but I am unable to find the correct
> link. Kindly share with me. If any one has the setup document.
>
> Also please confirm. Without using any third party s/w. We can do DB
> switch over and switch activity?
>
> Regards,
> Jayakumar.S
>

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

<div dir=3D"ltr">Hello,<div><br></div><div>If you did this with the replica=
tion method physically=C2=A0it&#39;s not possible. You can manage it with C=
rontab on the OS.=C2=A0</div><div><br></div><div>As an example ;<br>Switcho=
ver 1=C2=A0 from node 1 to node 2.=C2=A0<br>- Make failover on your replica=
.=C2=A0=C2=A0

<span style=3D"color:rgb(36,36,36);font-family:source-code-pro,Menlo,Monaco=
,&quot;Courier New&quot;,Courier,monospace;font-size:16px;letter-spacing:-0=
.352px;background-color:rgb(242,242,242)">sudo pg_ctlcluster 14 main </span=
><span class=3D"gmail-mu gmail-fr" style=3D"box-sizing:inherit;font-weight:=
700;font-family:source-code-pro,Menlo,Monaco,&quot;Courier New&quot;,Courie=
r,monospace;color:rgb(36,36,36);font-size:16px;letter-spacing:-0.352px;back=
ground-color:rgb(242,242,242)">promote</span><br>Switchover 2 :<br>On node =
1 clear your data path and make a new replica from node 2 to node 1 then ma=
ke failover again.</div><div><br></div><div>You can prepare the steps and m=
anage them with Crontab or some bash script. Bash script might work better =
for this I think.<br><br>It could work mostly with less data-sizing environ=
ments. If you have a load environment I would advice you to patroni cluster=
 system.</div><div><br></div><div>Have a nice weekend.</div></div><br><div =
class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">jayakumar s &lt=
;<a href=3D"mailto:kumardba27.postgresql@gmail.com">kumardba27.postgresql@g=
mail.com</a>&gt;, 22 Kas 2024 Cum, 18:59 tarihinde =C5=9Funu yazd=C4=B1:<br=
></div><blockquote 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>Hi Team,</div><div><br></div><div>I have configured master and slave DB=
&#39;s. Need to configure switcher and switch back setup. I checked google =
but I am unable to find the correct link. Kindly share with me. If any one =
has the setup document. <br></div><div><br></div><div>Also please confirm. =
Without using any third party s/w. We can do DB switch over and switch acti=
vity? <br></div><div><br></div><div>Regards,</div><div>Jayakumar.S<br></div=
></div>
</blockquote></div>

--000000000000f64b95062782db42--