public inbox for [email protected]  

help / color / mirror / Atom feed
From: Bo Peng <[email protected]>
To: Daniel Cifuentes <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Delete archived WALs on PRIMARY NODE
Date: Wed, 20 Aug 2025 09:15:36 +0000
Message-ID: <TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com>
References: <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com>

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 <[email protected]>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
Mobile: 080-7752-0749
URL: https://www.sraoss.co.jp/


________________________________________
差出人: Daniel Cifuentes <[email protected]>
送信: 2025 年 8 月 20 日 (水曜日) 5:52
宛先: [email protected] <[email protected]>
件名: 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.


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], [email protected]
  Subject: Re: Delete archived WALs on PRIMARY NODE
  In-Reply-To: <TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.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