MIME-Version: 1.0
From: p sn <tkdsud01@gmail.com>
Date: Mon, 11 Nov 2024 15:02:44 +0900
Message-ID: 
 <CA+Z6K-U_hSkoCeBu5WLrxyz4kHNnj_orFP3cghBHj_di3OW9+g@mail.gmail.com>
Subject: Inquiry on Setting Up Automatic Failover with Stream Replication
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000f698006269cdad5"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BZ6K-U_hSkoCeBu5WLrxyz4kHNnj_orFP3cghBHj_di3OW9%2Bg%40mail.gmail.com>
Precedence: bulk

--0000000000000f698006269cdad5
Content-Type: text/plain; charset="UTF-8"

  Hello, I am currently setting up PostgreSQL Stream Replication for a
replication configuration.

 I am using PostgreSQL version 14.12 on a RedHat 8.9 environment,
and my setup consists of a Primary-Standby replication configuration with
two nodes.
 Due to certain constraints, I cannot add more nodes or use external nodes.

  Questions:
    1-1. How should I configure postgresql.conf and pg_hba.conf for this
setup? I would like to implement automatic failover with only these two
nodes.
    1-2. Is it possible to achieve this setup? If so, could you advise on
the specific configuration steps needed? I would greatly appreciate any
guidance from those with experience in this area. Thank you.


 Best regards,

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

<div dir=3D"ltr">=C2=A0 Hello,

I am currently setting up PostgreSQL Stream Replication <span class=3D"gmai=
l-hljs-keyword">for</span> a replication configuration.=C2=A0<div><br></div=
><div>=C2=A0I am <span class=3D"gmail-hljs-keyword">using</span> PostgreSQL=
 version <span class=3D"gmail-hljs-number">14.12</span> <span class=3D"gmai=
l-hljs-keyword">on</span> a RedHat=C2=A0<span class=3D"gmail-hljs-number">8=
.9</span> environment,=C2=A0<div><span class=3D"gmail-hljs-built_in">and</s=
pan> my setup consists <span class=3D"gmail-hljs-keyword">of</span> a Prima=
ry-Standby replication configuration <span class=3D"gmail-hljs-keyword">wit=
h</span> two nodes.</div><div>=C2=A0Due <span class=3D"gmail-hljs-keyword">=
to</span> certain constraints, I cannot add more nodes <span class=3D"gmail=
-hljs-built_in">or</span> use external nodes.=C2=A0</div><div><br></div><di=
v>=C2=A0
<span class=3D"gmail-hljs-symbol">Questions:</span>=C2=A0</div><div><span c=
lass=3D"gmail-hljs-number">=C2=A0 =C2=A0 1-1</span>. How should I configure=
 postgresql.conf <span class=3D"gmail-hljs-built_in">and</span> pg_hba.conf=
 <span class=3D"gmail-hljs-keyword">for</span> this setup?

I would <span class=3D"gmail-hljs-built_in">like</span> <span class=3D"gmai=
l-hljs-keyword">to</span> implement automatic failover <span class=3D"gmail=
-hljs-keyword">with</span> only these two nodes.=C2=A0</div><div><span clas=
s=3D"gmail-hljs-built_in">=C2=A0 =C2=A0 1-2. Is</span> it possible <span cl=
ass=3D"gmail-hljs-keyword">to</span> achieve this setup? <span class=3D"gma=
il-hljs-keyword">If</span> so, could you advise <span class=3D"gmail-hljs-k=
eyword">on</span> the specific configuration steps needed? I would greatly =
appreciate any guidance <span class=3D"gmail-hljs-keyword">from</span> thos=
e <span class=3D"gmail-hljs-keyword">with</span> experience <span class=3D"=
gmail-hljs-keyword">in</span> this area. Thank you.=C2=A0</div><div><br></d=
iv><div><br></div><div>=C2=A0Best regards,=C2=A0=C2=A0</div></div></div>

--0000000000000f698006269cdad5--