Re: Delete archived WALs on PRIMARY NODE

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.

In response to

Responses

Browse pgpool-general by date

  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