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.
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 |