MIME-Version: 1.0
References: <CAKgGyB8D_EguU9E73ZiZoquLn6==a_G=MtiErd45Hme9MzZ-3A@mail.gmail.com>
In-Reply-To: <CAKgGyB8D_EguU9E73ZiZoquLn6==a_G=MtiErd45Hme9MzZ-3A@mail.gmail.com>
From: Ruben Morais <ruben.gmorais@gmail.com>
Date: Mon, 19 Aug 2024 14:20:44 +0100
Message-ID: <CAG8sLzuiX5AXGAOSesK-gSzAEpV6BLciUhBnwSyVXbuhCn3Utg@mail.gmail.com>
Subject: Re: WAL replication and Archive command for pgbackrest on same server conf
To: KK CHN <kkchn.in@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d340dd0620092dac"
Archived-At: <https://www.postgresql.org/message-id/CAG8sLzuiX5AXGAOSesK-gSzAEpV6BLciUhBnwSyVXbuhCn3Utg%40mail.gmail.com>
Precedence: bulk

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

hi,

you can combine:

archive_command =3D 'pgbackrest --stanza=3DDemo  archive-push  %p && cp %p
/data/archive/%f '

You need to change your standby replica to consume the wals from pgbackrest
if you want instead to use both commands.

*R=C3=BAben Morais*

 *(+351) 965775713*
<https://pt.linkedin.com/pub/r=C3=BAben-morais/21/b44/b99>
*ruben.gmorais@gmail.com
<ruben.gmorais@gmail.com>*


On Mon, Aug 19, 2024 at 2:10=E2=80=AFPM KK CHN <kkchn.in@gmail.com> wrote:

> 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 =3Don
> 2. archive_level=3Dreplica
> 3. archive_command =3D '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 =3D 'pgbackrest --stanza=3DDemo  archive-push  cp %p
> /data/archive/%f '
>
>
>
> Please correct me If I am doing wrong in the above line..
>
>
> Thank you,
> Krish
>

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

<div dir=3D"ltr">hi,=C2=A0<div><br></div><div>you can combine:</div><div><b=
r></div><div>archive_command =3D &#39;pgbackrest --stanza=3DDemo=C2=A0 arch=
ive-push=C2=A0 %p &amp;&amp; cp %p /data/archive/%f &#39;</div><div><br></d=
iv><div>You need to change your standby replica to consume the wals=C2=A0fr=
om pgbackrest if you want instead to use both commands.</div><div><br clear=
=3D"all"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"=
gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"lt=
r"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><=
div dir=3D"ltr"><div><div dir=3D"ltr"><div><b>R=C3=BAben Morais</b></div><d=
iv><b><br></b></div></div></div></div></div><div><div dir=3D"ltr"><div><div=
 dir=3D"ltr"><div><img src=3D"http://i.imgbox.com/N5da8O9m.png">=C2=A0<span=
 style=3D"font-size:12.8000001907349px"><b>(+351) 965775713</b>=C2=A0 =C2=
=A0=C2=A0</span><a href=3D"https://pt.linkedin.com/pub/r=C3=BAben-morais/21=
/b44/b99" target=3D"_blank"><img src=3D"http://i.imgbox.com/AxuYLW92.png" s=
tyle=3D"font-size:12.8000001907349px"></a>=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0<i=
mg src=3D"http://i.imgbox.com/XNvl713A.png">=C2=A0<b><a href=3D"mailto:rube=
n.gmorais@gmail.com" target=3D"_blank">ruben.gmorais@gmail.com</a></b></div=
></div></div></div></div></div></div></div></div></div></div></div></div></=
div></div></div></div></div><br></div></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, Aug 19, 2024 at 2:10=E2=80=AF=
PM KK CHN &lt;<a href=3D"mailto:kkchn.in@gmail.com">kkchn.in@gmail.com</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div =
dir=3D"ltr">Hi List ,<div><br></div><div>I am trying to configure the pgbac=
krest=C2=A0 on a live server ( RHEL9, EPAS16 and Pgbacrest .2.52)=C2=A0 whi=
ch is having a working=C2=A0 =C2=A0WAL archive configuration=C2=A0 to a sta=
ndby 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. archive_co=
mmand =3D &#39;cp %p /data/archive/%f&#39;=C2=A0=C2=A0<br></div></div><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 WAL=C2=A0=
configuration as well as my new pgbackrest option both will work smoothly.=
=C2=A0 =C2=A0how to add an entry=C2=A0 in line 3=C2=A0 ??</div><div><br></d=
iv><div>archive_command =3D &#39;pgbackrest --stanza=3DDemo=C2=A0 archive-p=
ush=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>
</blockquote></div>

--000000000000d340dd0620092dac--