| From: | Bo Peng <pengbo(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | Daniel Cifuentes <daercimi(at)gmail(dot)com>, "pgpool-general(at)lists(dot)postgresql(dot)org" <pgpool-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Delete archived WALs on PRIMARY NODE |
| Date: | 2025-08-20 09:15:36 |
| Message-ID: | TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-general |
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(at)sraoss(dot)co(dot)jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
Mobile: 080-7752-0749
URL: https://www.sraoss.co.jp/
________________________________________
差出人: Daniel Cifuentes <daercimi(at)gmail(dot)com>
送信: 2025 年 8 月 20 日 (水曜日) 5:52
宛先: pgpool-general(at)lists(dot)postgresql(dot)org <pgpool-general(at)lists(dot)postgresql(dot)org>
件名: 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 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).
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Cifuentes | 2025-08-20 15:48:56 | Re: Delete archived WALs on PRIMARY NODE |
| Previous Message | Daniel Cifuentes | 2025-08-19 20:52:22 | Delete archived WALs on PRIMARY NODE |