public inbox for [email protected]
help / color / mirror / Atom feedFrom: Daniel Cifuentes <[email protected]>
To: [email protected]
Subject: Delete archived WALs on PRIMARY NODE
Date: Tue, 19 Aug 2025 15:52:22 -0500
Message-ID: <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com> (raw)
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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Delete archived WALs on PRIMARY NODE
In-Reply-To: <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox