Re: Postgre's replica holding huge amount of WAL - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Postgre's replica holding huge amount of WAL
Date
Msg-id 0ec3ad712a1b8bd63b807091e61e11e5e069b720.camel@cybertec.at
Whole thread Raw
In response to Postgre's replica holding huge amount of WAL  (Mendbayar Alzakhgui <mendbayar.alz@unitel.mn>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Daulat
Date:
Subject: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.