public inbox for [email protected]
help / color / mirror / Atom feedFrom: Daniel Cifuentes <[email protected]>
To: Bo Peng <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Delete archived WALs on PRIMARY NODE
Date: Wed, 20 Aug 2025 10:48:56 -0500
Message-ID: <CAAZke63VCBA+6H=vVs9sV0EO-e4_MVGTYZAHLWKGz6jxkE8BEw@mail.gmail.com> (raw)
In-Reply-To: <TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.COM>
References: <CAAZke61DoOcH0gr3f8kRiXEtW60tamP6Fwy9qfoDxVwcoOtvkA@mail.gmail.com>
<TY3P286MB264214ADE7D4AB1699357F16F233A@TY3P286MB2642.JPNP286.PROD.OUTLOOK.COM>
👍
Daniel Cifuentes reaccionó a través de Gmail
<https://www.google.com/gmail/about/?utm_source=gmail-in-product&utm_medium=et&utm_campaign=e...;
El mié, 20 ago 2025 a las 4:15, Bo Peng (<[email protected]>) 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 <[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: <CAAZke63VCBA+6H=vVs9sV0EO-e4_MVGTYZAHLWKGz6jxkE8BEw@mail.gmail.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