Re: Delete archived WALs on PRIMARY NODE

👍

Daniel Cifuentes reaccionó a través de Gmail
<https://www.google.com/gmail/about/?utm_source=gmail-in-product&utm_medium=et&utm_campaign=emojireactionemail#app>

El mié, 20 ago 2025 a las 4:15, Bo Peng (<pengbo(at)sraoss(dot)co(dot)jp>) escribió:

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