MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Tue, 15 Oct 2024 22:40:53 +0530
Message-ID: <CAKgGyB-Mm6dorL2bFJA-9ZG04C99X+T-nQuYis9T0TU0OVSx0A@mail.gmail.com>
Subject: WAL replication standby server: query
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fb849106248709cc"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB-Mm6dorL2bFJA-9ZG04C99X%2BT-nQuYis9T0TU0OVSx0A%40mail.gmail.com>
Precedence: bulk

--000000000000fb849106248709cc
Content-Type: text/plain; charset="UTF-8"

List ,

I am trying  to  configure a WAL replicated  standby server(EDB16) ..   In
the archive command  I used a dedicated  "/data/archive " directory  for
WAL archiving as follows, as I don't want any WAL overwriting in the
default WAL directory and loss of WAL files.

I have
archive_command=  ' cp %p /data/archive/%f '

pg_hba.conf    I have

host replication     all             10.255.10.0/24              md5

My doubt is whether the standby Postgres server(EDB16) reads WAL files by
itself   from the primary server's  explicit WAL archive folder
/data/archive  by its own  ?
OR
  The standby can read  only from the default WAL location  ie; pg_wal
 directory of primary server ?

Please  enlighten me.

If the standby can read only the default pg_wal folder, then how can we
make the standby server to read from the explicit  " /data/archive "
folder for WAL syncing automatically to the standby ?

Any input is much appreciated.

Thank you,
Krishane

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

<div dir=3D"ltr">List ,<div><br></div><div>I am trying=C2=A0=C2=A0to=C2=A0 =
configure a WAL replicated=C2=A0 standby server(EDB16) ..=C2=A0 =C2=A0In th=
e archive command=C2=A0 I used a dedicated=C2=A0 &quot;/data/archive &quot;=
 directory=C2=A0 for WAL archiving as follows, as I don&#39;t want any WAL =
overwriting in the default WAL directory and loss of WAL files.=C2=A0</div>=
<div><br></div><div>I have</div><div>archive_command=3D=C2=A0 &#39; cp %p /=
data/archive/%f &#39;<br></div><div><br></div><div>pg_hba.conf=C2=A0 =C2=A0=
 I have</div><div><br></div><div>host=C2=A0replication =C2=A0 =C2=A0 all =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"http://10.255.10.0/24"=
>10.255.10.0/24</a>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 md5</di=
v><div><br></div><div>My doubt is whether=C2=A0the standby Postgres server(=
EDB16) reads WAL files by itself=C2=A0 =C2=A0from the primary server&#39;s=
=C2=A0 explicit WAL archive folder /data/archive=C2=A0 by its own=C2=A0 ?=
=C2=A0</div><div>OR</div><div>=C2=A0 The standby can read=C2=A0 only from t=
he default=C2=A0WAL location=C2=A0 ie; pg_wal=C2=A0 =C2=A0directory of prim=
ary server ?=C2=A0</div><div><br></div><div>Please=C2=A0 enlighten me.</div=
><div><br></div><div>If the standby can read only the default=C2=A0pg_wal f=
older, then how can we make the standby server to read from the explicit=C2=
=A0 &quot; /data/archive &quot;=C2=A0 folder for WAL syncing automatically =
to the standby ?</div><div><br></div><div>Any input is much=C2=A0appreciate=
d.</div><div><br></div><div>Thank you,</div><div>Krishane</div></div>

--000000000000fb849106248709cc--