public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Mendbayar Alzakhgui <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Postgre's replica holding huge amount of WAL
Date: Thu, 15 May 2025 14:27:57 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <SEZPR01MB5748AB66F48B9A164728F4A0EA90A@SEZPR01MB5748.apcprd01.prod.exchangelabs.com>
References: <SEZPR01MB5748AB66F48B9A164728F4A0EA90A@SEZPR01MB5748.apcprd01.prod.exchangelabs.com>
On Thu, 2025-05-15 at 06:21 +0000, Mendbayar Alzakhgui wrote:
> My PostgreSQL is a cluster that managed by Patroni and etcd. While it has 2 replica server
> both of the replica’s are holding huge amount of WAL file (current 55GB since 29th April).
> I’ve checked the replay delay, wal_keep_size, replication slot, max_wal_size but all of
> them were fine there’s no slot keeping that wal in replica for sure even in master there’s
> no slot holding that WAL, wal_keep_size is 5GB and max_wal_size is 8GB and delay is almost
> 0.02 second almost no delay. But there’s no that size of WAL in master node.
> What’s the troubleshoot of this case, how to check it?
https://www.cybertec-postgresql.com/en/why-does-my-pg_wal-keep-growing/
Yours,
Laurenz Albe
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: Postgre's replica holding huge amount of WAL
In-Reply-To: <[email protected]>
* 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