Re: Postgre's replica holding huge amount of WAL

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Mendbayar Alzakhgui <mendbayar(dot)alz(at)unitel(dot)mn>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgre's replica holding huge amount of WAL
Date: 2025-05-15 12:27:57
Message-ID: 0ec3ad712a1b8bd63b807091e61e11e5e069b720.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2025-05-16 17:10:15 pg_stat_statements, write activity
Previous Message Akshay Joshi 2025-05-15 10:18:35 Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.