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
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. |