MIME-Version: 1.0
References: 
 <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com>
 <TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.COM>
In-Reply-To: 
 <TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.COM>
From: Daniel Cifuentes <daercimi@gmail.com>
Date: Wed, 20 Aug 2025 10:48:56 -0500
Message-ID: 
 <CAAZke63VCBA+6H=vVs9sV0EO-e4_MVGTYZAHLWKGz6jxkE8BEw@mail.gmail.com>
Subject: Re: Delete archived WALs on PRIMARY NODE
To: Bo Peng <pengbo@sraoss.co.jp>
Cc: "pgpool-general@lists.postgresql.org"
 <pgpool-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d6d8ca063ccde953"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAZke63VCBA%2B6H%3DvVs9sV0EO-e4_MVGTYZAHLWKGz6jxkE8BEw%40mail.gmail.com>
Precedence: bulk

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

=F0=9F=91=8D

Daniel Cifuentes reaccion=C3=B3 a trav=C3=A9s de Gmail
<https://www.google.com/gmail/about/?utm_source=3Dgmail-in-product&utm_medi=
um=3Det&utm_campaign=3Demojireactionemail#app>

El mi=C3=A9, 20 ago 2025 a las 4:15, Bo Peng (<pengbo@sraoss.co.jp>) escrib=
i=C3=B3:

> Hi,
>
> > So a solution would be doing an upgrade and setting off the archive
> mode? Is that the best solution?
> > Thank you in advance for your help.
>
> Upgrade is not necessary.
>
> You can disable archive_mode in PostgreSQL and modify the follow_primary
> and online_recovery scripts to disable archive_mode.
>
> ---
> Bo Peng <pengbo@sraoss.co.jp>
> SRA OSS K.K.
> TEL: 03-5979-2701 FAX: 03-5979-2702
> Mobile: 080-7752-0749
> URL: https://www.sraoss.co.jp/
>
>
> ________________________________________
> =E5=B7=AE=E5=87=BA=E4=BA=BA: Daniel Cifuentes <daercimi@gmail.com>
> =E9=80=81=E4=BF=A1: 2025 =E5=B9=B4 8 =E6=9C=88 20 =E6=97=A5 (=E6=B0=B4=E6=
=9B=9C=E6=97=A5) 5:52
> =E5=AE=9B=E5=85=88: pgpool-general@lists.postgresql.org <
> pgpool-general@lists.postgresql.org>
> =E4=BB=B6=E5=90=8D: Delete archived WALs on PRIMARY NODE
>
>
>
>
>
>
>
>
>
>
>
> Hello, I have a cluster with
> Postgres 16.4
> Pgpool-II 4.5.4
> The problem that I am having is that the directory for archives is gettin=
g
> full with all the old archives. I have done some testing and proved that
> the replication is ok.
> I have read about the pg_archivecleanup command but the documentation say=
s
> that the command is designed for standby servers (PostgreSQL:
> Documentation: 16: pg_archivecleanup).
>
>
> What I have noticed is that Pgpool 4.5.4 documentation indicates:
>
>
> Archive mode
> on
> /var/lib/pgsql/archivedirPgpool-II + Watchdog Setup Example
>
>
> While 4.6.2 version says:
>
>
> Archive mode
> offPgpool-II + Watchdog Setup Example
>
> So a solution would be doing an upgrade and setting off the archive mode?
> Is that the best solution?
> Thank you in advance for your help.
>

--000000000000d6d8ca063ccde953
Content-Type: text/vnd.google.email-reaction+json; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

{
  "emoji": "=F0=9F=91=8D",
  "version": 1
}
--000000000000d6d8ca063ccde953
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div><p style=3D"font-size:50px;margin-top:0;margin-bottom:0">=F0=9F=91=8D<=
/p><p style=3D"margin-top:10px;margin-bottom:0">Daniel Cifuentes reaccion=
=C3=B3 a trav=C3=A9s de <a href=3D"https://www.google.com/gmail/about/?utm_=
source=3Dgmail-in-product&amp;utm_medium=3Det&amp;utm_campaign=3Demojireact=
ionemail#app">Gmail</a></p></div><br><div class=3D"gmail_quote gmail_quote_=
container"><div dir=3D"ltr" class=3D"gmail_attr">El mi=C3=A9, 20 ago 2025 a=
 las 4:15, Bo Peng (&lt;<a href=3D"mailto:pengbo@sraoss.co.jp">pengbo@sraos=
s.co.jp</a>&gt;) escribi=C3=B3:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,=
<br>
<br>
&gt; So a solution would be doing an upgrade and setting off the archive mo=
de? Is that the best solution?=C2=A0<br>
&gt; Thank you in advance for your help.<br>
<br>
Upgrade is not necessary.<br>
<br>
You can disable archive_mode in PostgreSQL and modify the follow_primary an=
d online_recovery scripts to disable archive_mode.<br>
<br>
---<br>
Bo Peng &lt;<a href=3D"mailto:pengbo@sraoss.co.jp" target=3D"_blank">pengbo=
@sraoss.co.jp</a>&gt;<br>
SRA OSS K.K.<br>
TEL: 03-5979-2701 FAX: 03-5979-2702<br>
Mobile: 080-7752-0749<br>
URL: <a href=3D"https://www.sraoss.co.jp/" rel=3D"noreferrer" target=3D"_bl=
ank">https://www.sraoss.co.jp/</a><br>
<br>
<br>
________________________________________<br>
=E5=B7=AE=E5=87=BA=E4=BA=BA: Daniel Cifuentes &lt;<a href=3D"mailto:daercim=
i@gmail.com" target=3D"_blank">daercimi@gmail.com</a>&gt;<br>
=E9=80=81=E4=BF=A1: 2025 =E5=B9=B4 8 =E6=9C=88 20 =E6=97=A5 (=E6=B0=B4=E6=
=9B=9C=E6=97=A5) 5:52<br>
=E5=AE=9B=E5=85=88: <a href=3D"mailto:pgpool-general@lists.postgresql.org" =
target=3D"_blank">pgpool-general@lists.postgresql.org</a> &lt;<a href=3D"ma=
ilto:pgpool-general@lists.postgresql.org" target=3D"_blank">pgpool-general@=
lists.postgresql.org</a>&gt;<br>
=E4=BB=B6=E5=90=8D: Delete archived WALs on PRIMARY NODE<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Hello, I have a cluster with<br>
Postgres 16.4<br>
Pgpool-II 4.5.4<br>
The problem that I am having is that the directory for archives is getting =
full with all the old archives. I have done some testing and proved that th=
e replication is ok.<br>
I have read about the=C2=A0pg_archivecleanup=C2=A0command but the documenta=
tion says that the command is designed for standby servers (PostgreSQL: Doc=
umentation: 16: pg_archivecleanup).<br>
<br>
<br>
What I have noticed is that Pgpool 4.5.4 documentation indicates:<br>
<br>
<br>
Archive mode<br>
on<br>
/var/lib/pgsql/archivedirPgpool-II + Watchdog Setup Example<br>
<br>
<br>
While 4.6.2 version says:<br>
<br>
<br>
Archive mode<br>
offPgpool-II + Watchdog Setup Example<br>
<br>
So a solution would be doing an upgrade and setting off the archive mode? I=
s that the best solution?=C2=A0<br>
Thank you in advance for your help.<br>
</blockquote></div>

--000000000000d6d8ca063ccde953--