MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Fri, 6 Jun 2025 07:45:27 -0700
Message-ID: 
 <CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com>
Subject: Replication and Switchover
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Peter Garza <peter.garza@dat.com>, Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="0000000000008fe3a90636e84863"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVj%3D01f6At2L4X7WM8g1c%2B18up8mSLB1GSKzJdJNAEUtaag%40mail.gmail.com>
Precedence: bulk

--0000000000008fe3a90636e84863
Content-Type: text/plain; charset="UTF-8"

Howdy,

We have 2 databases running out of a single database cluster.  We would
like to set up replication from the existing host to a new host and then
switchover to that new host.  One of the databases is ready to switchover
now while the other database is going to take a bit more time to be ready
for the switchover.

We would like to switchover the database that is ready now so we can start
performing load testing against it.  Is it possible to switchover one
database in a cluster while not switching over the other?

Thanks,

Sam

-- 

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

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

<div dir=3D"ltr"><div>Howdy,</div><div><br></div><div>We have 2 databases=
=C2=A0running out of a single database cluster.=C2=A0 We would like to set =
up=C2=A0replication from the existing host to a new host and then switchove=
r to that new host.=C2=A0 One of the databases is ready to switchover now w=
hile the other database is going to take a bit more time to be ready for th=
e switchover.=C2=A0</div><div><br></div><div>We would like to switchover th=
e database that is ready now so we can start performing=C2=A0load testing a=
gainst it.=C2=A0 Is it possible to switchover one database in a cluster whi=
le not switching over the other?</div><div><br></div><div>Thanks,</div><div=
><br></div><div>Sam</div><div><br></div><span class=3D"gmail_signature_pref=
ix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=
=3D"gmail_signature"><div dir=3D"ltr"><span><p dir=3D"ltr" style=3D"line-he=
ight:1.38;margin-top:10pt;margin-bottom:10pt"><span style=3D"font-size:11pt=
;font-family:Inter,sans-serif;color:rgb(51,51,51);background-color:transpar=
ent;font-weight:700;vertical-align:baseline">Samuel Stearns</span><span sty=
le=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(51,51,51);backg=
round-color:transparent;font-weight:700;vertical-align:baseline"><br></span=
><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,1=
02,102);background-color:transparent;vertical-align:baseline">Team Lead - D=
atabase</span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;co=
lor:rgb(102,102,102);background-color:transparent;vertical-align:baseline">=
<br></span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color=
:rgb(102,102,102);background-color:transparent;vertical-align:baseline">c: =
971 762 6879 </span><span style=3D"font-size:11pt;font-family:Inter,sans-se=
rif;color:rgb(147,149,152);background-color:transparent;vertical-align:base=
line">|</span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;co=
lor:rgb(102,102,102);background-color:transparent;vertical-align:baseline">=
 o: 971 762 6879 </span><span style=3D"font-size:11pt;font-family:Inter,san=
s-serif;color:rgb(147,149,152);background-color:transparent;vertical-align:=
baseline">|</span><span style=3D"font-size:11pt;font-family:Inter,sans-seri=
f;color:rgb(102,102,102);background-color:transparent;vertical-align:baseli=
ne"> DAT.com</span></p><p dir=3D"ltr" style=3D"line-height:1.38;margin-top:=
0pt;margin-bottom:0pt"><a href=3D"https://www.dat.com/?utm_medium=3Demail&a=
mp;utm_source=3DDAT_email_signature_link" target=3D"_blank"><span style=3D"=
font-size:11pt;font-family:Arial,sans-serif;color:rgb(17,85,204);background=
-color:transparent;vertical-align:baseline"><span style=3D"border:none;disp=
lay:inline-block;overflow:hidden;width:126px;height:54px"><img src=3D"https=
://lh7-rt.googleusercontent.com/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIA=
rmSrehhAl-cXaYxECakbMV5owUfMaMjAZZcbjttr8pEtSGrZjUSRNaxbLxumAthLgYlFE5iT2P2=
eOJu4jtqizp_fYM0Mq1DZyFUeHMhpGKjiGIzqD_ny_hPIzlt?key=3Dz3dM0-Cr9WzKyLauPVBg=
Ww" width=3D"126" height=3D"54" style=3D"margin-left:0px;margin-top:0px"></=
span></span></a></p><div><br></div></span></div></div></div>

--0000000000008fe3a90636e84863--