MIME-Version: 1.0
From: Daniel Cifuentes <daercimi@gmail.com>
Date: Tue, 19 Aug 2025 15:52:22 -0500
Message-ID: 
 <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com>
Subject: Delete archived WALs on PRIMARY NODE
To: pgpool-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000063ecd5063cbe0997"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA%40mail.gmail.com>
Precedence: bulk

--00000000000063ecd5063cbe0997
Content-Type: text/plain; charset="UTF-8"

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 getting
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 says
that the command is designed for standby servers (PostgreSQL:
Documentation: 16: pg_archivecleanup
<https://www.postgresql.org/docs/16/pgarchivecleanup.html>).

What I have noticed is that Pgpool 4.5.4 documentation indicates:
Archive mode on /var/lib/pgsql/archivedirPgpool-II + Watchdog Setup Example
<https://www.pgpool.net/docs/pgpool-II-4.5.4/en/html/example-cluster.html>

While 4.6.2 version says:
Archive mode offPgpool-II + Watchdog Setup Example
<https://www.pgpool.net/docs/latest/en/html/example-cluster.html>

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.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"lt=
r">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 the re=
plication is ok.</div><div><span>I have read about the=C2=A0</span>pg_archi=
vecleanup=C2=A0command but the documentation says that the command is desig=
ned for standby servers (<a href=3D"https://www.postgresql.org/docs/16/pgar=
chivecleanup.html">PostgreSQL: Documentation: 16: pg_archivecleanup</a>).<b=
r><br></div><div>What I have noticed is that Pgpool 4.5.4 documentation ind=
icates:<br><table border=3D"1" class=3D"gmail-CALSTABLE" style=3D"border-sp=
acing:0px;border-collapse:collapse;margin:2ex 0px 2ex 2ex;background-color:=
rgb(224,236,239);border:2px solid rgb(167,198,223);color:rgb(0,0,0);font-fa=
mily:verdana,sans-serif;font-size:medium"><tbody><tr><td style=3D"border:1p=
x solid rgb(167,198,223);background-color:rgb(239,239,239);padding:0.5ex">A=
rchive mode</td><td style=3D"border:1px solid rgb(167,198,223);background-c=
olor:rgb(239,239,239);padding:0.5ex">on</td><td style=3D"border:1px solid r=
gb(167,198,223);background-color:rgb(239,239,239);padding:0.5ex">/var/lib/p=
gsql/archivedir</td></tr></tbody></table><a href=3D"https://www.pgpool.net/=
docs/pgpool-II-4.5.4/en/html/example-cluster.html">Pgpool-II + Watchdog Set=
up Example</a></div><div dir=3D"ltr"><div><br>While 4.6.2 version says:<br>=
<table border=3D"1" class=3D"gmail-CALSTABLE" style=3D"border-spacing:0px;b=
order-collapse:collapse;margin:2ex 0px 2ex 2ex;background-color:rgb(224,236=
,239);border:2px solid rgb(167,198,223);color:rgb(0,0,0);font-family:verdan=
a,sans-serif;font-size:medium"><tbody><tr><td style=3D"border:1px solid rgb=
(167,198,223);background-color:rgb(239,239,239);padding:0.5ex">Archive mode=
</td><td style=3D"border:1px solid rgb(167,198,223);background-color:rgb(23=
9,239,239);padding:0.5ex">off</td></tr></tbody></table><a href=3D"https://w=
ww.pgpool.net/docs/latest/en/html/example-cluster.html">Pgpool-II + Watchdo=
g Setup Example</a><br><br>So a solution would be doing an upgrade and sett=
ing off the archive mode? Is that the best solution?=C2=A0</div><div>Thank =
you in advance for your help.</div></div></div></div></div></div></div></di=
v></div></div>

--00000000000063ecd5063cbe0997--