MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Mon, 19 Aug 2024 18:40:05 +0530
Message-ID: <CAKgGyB8D_EguU9E73ZiZoquLn6==a_G=MtiErd45Hme9MzZ-3A@mail.gmail.com>
Subject: WAL replication and Archive command for pgbackrest on same server conf
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000010465a062009071c"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB8D_EguU9E73ZiZoquLn6%3D%3Da_G%3DMtiErd45Hme9MzZ-3A%40mail.gmail.com>
Precedence: bulk

--00000000000010465a062009071c
Content-Type: text/plain; charset="UTF-8"

Hi List ,

I am trying to configure the pgbackrest  on a live server ( RHEL9, EPAS16
and Pgbacrest .2.52)  which is having a working   WAL archive
configuration  to a standby server in postgresql.conf as follows


1. archive_mod =on
2. archive_level=replica
3. archive_command = 'cp %p /data/archive/%f'


To do the pgbackrest conf on the same   archive_command   directive (So
both the existing WAL configuration as well as my new pgbackrest option
both will work smoothly.   how to add an entry  in line 3  ??

archive_command = 'pgbackrest --stanza=Demo  archive-push  cp %p
/data/archive/%f '


Please correct me If I am doing wrong in the above line..


Thank you,
Krish

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

<div dir=3D"ltr">Hi List ,<div><br></div><div>I am trying to configure the =
pgbackrest=C2=A0 on a live server ( RHEL9, EPAS16 and Pgbacrest .2.52)=C2=
=A0 which is having a working=C2=A0 =C2=A0WAL archive configuration=C2=A0 t=
o a standby server in postgresql.conf as follows</div><div><br></div><div><=
br><div>1. archive_mod =3Don</div><div>2. archive_level=3Dreplica<br>3. arc=
hive_command =3D &#39;cp %p /data/archive/%f&#39;=C2=A0=C2=A0<br></div></di=
v><div><br></div><div><br></div><div>To do the pgbackrest conf on the same=
=C2=A0 =C2=A0archive_command=C2=A0 =C2=A0directive (So both the existing WA=
L=C2=A0configuration as well as my new pgbackrest option both will work smo=
othly.=C2=A0 =C2=A0how to add an entry=C2=A0 in line 3=C2=A0 ??</div><div><=
br></div><div>archive_command =3D &#39;pgbackrest --stanza=3DDemo=C2=A0 arc=
hive-push=C2=A0 cp %p /data/archive/%f &#39;</div><div><br></div><div><br><=
/div><div><br></div><div>Please correct me If I am doing wrong in the above=
 line..</div><div><br></div><div><br></div><div>Thank you,</div><div>Krish=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0<br></div></div>

--00000000000010465a062009071c--