Delete archived WALs on PRIMARY NODE

From: Daniel Cifuentes <daercimi(at)gmail(dot)com>
To: pgpool-general(at)lists(dot)postgresql(dot)org
Subject: Delete archived WALs on PRIMARY NODE
Date: 2025-08-19 20:52:22
Message-ID: CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-general

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.

Responses

Browse pgpool-general by date

  From Date Subject
Next Message Bo Peng 2025-08-20 09:15:36 Re: Delete archived WALs on PRIMARY NODE
Previous Message Tatsuo Ishii 2025-08-14 00:41:06 Re: Sudden increase in connections in pgpool usage environment