MIME-Version: 1.0
References: 
 <CAOF-KfhGM28vyE+HShrfnTNx8PYBeyTkiNGDA_xPF1DDS_PEHg@mail.gmail.com>
 <a50f44d5dbb3bef00594c7539479b29ca464a0dc.camel@cybertec.at>
In-Reply-To: <a50f44d5dbb3bef00594c7539479b29ca464a0dc.camel@cybertec.at>
From: Yang Steve <steve25insydney.yang@gmail.com>
Date: Fri, 12 May 2023 23:45:53 +1000
Message-ID: 
 <CAH4uYX5dweEnoUgi8Z4tLfuX7K3stY84N+Z=iq9sxsQB=pY2Kg@mail.gmail.com>
Subject: Re: recovery.conf and archive_cleanup_command
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Rita <rmorgan466@gmail.com>, pgsql-novice@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000957b7e05fb7f531d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAH4uYX5dweEnoUgi8Z4tLfuX7K3stY84N%2BZ%3Diq9sxsQB%3DpY2Kg%40mail.gmail.com>
Precedence: bulk

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

I am using PostgreSQL Version 15 now, however, archive_cleanup_command only
triggered on standby box, not on primary. Is that expected as designing?

Laurenz Albe <laurenz.albe@cybertec.at> =E4=BA=8E2022=E5=B9=B410=E6=9C=8810=
=E6=97=A5=E5=91=A8=E4=B8=80 04:33=E5=86=99=E9=81=93=EF=BC=9A

> On Sat, 2022-10-08 at 08:51 -0400, Rita wrote:
> > I have primary and standby replication setup.
> >
> > On my primary the archive directory is rather large (30GB) and growing.
> On my standby I have recovery.conf which has
> > archive_cleanup_command =3D 'pg_archivecleanup -d
> /var/lib/pgsql/11/data/archive %r'
> >
> > I was under the impression this line would remove data from my primary
> AND standby. Is that not the case?
>
> That depends on your PostgreSQL version, for instance.
>
> Also, it depends on whether the standby server is running and actually
> recovering.
> Finally, it depends on whether the standby can execute the command
> successfully or not.
>
> Did you look at the standby's logs?
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
>

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

<div dir=3D"ltr">I am using PostgreSQL Version 15 now, however,=C2=A0<span =
style=3D"color:rgb(80,0,80)">archive_cleanup_command only triggered on stan=
dby box, not on primary. Is that expected as designing?=C2=A0</span></div><=
br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">Laurenz=
 Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec=
.at</a>&gt; =E4=BA=8E2022=E5=B9=B410=E6=9C=8810=E6=97=A5=E5=91=A8=E4=B8=80 =
04:33=E5=86=99=E9=81=93=EF=BC=9A<br></div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex">On Sat, 2022-10-08 at 08:51 -0400, Rita wrote:<br>
&gt; I have primary and standby replication setup.<br>
&gt; <br>
&gt; On my primary the archive directory is rather large (30GB) and growing=
. On my standby I have recovery.conf which has=C2=A0<br>
&gt; archive_cleanup_command =3D &#39;pg_archivecleanup -d /var/lib/pgsql/1=
1/data/archive %r&#39;<br>
&gt; <br>
&gt; I was under the impression this line would remove data from my primary=
 AND standby. Is that not the case?<br>
<br>
That depends on your PostgreSQL version, for instance.<br>
<br>
Also, it depends on whether the standby server is running and actually reco=
vering.<br>
Finally, it depends on whether the standby can execute the command successf=
ully or not.<br>
<br>
Did you look at the standby&#39;s logs?<br>
<br>
Yours,<br>
Laurenz Albe<br>
-- <br>
Cybertec | <a href=3D"https://www.cybertec-postgresql.com" rel=3D"noreferre=
r" target=3D"_blank">https://www.cybertec-postgresql.com</a><br>
<br>
<br>
</blockquote></div>

--000000000000957b7e05fb7f531d--