Re: Return of the pg_wal issue..

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Paul Brindusa <paulbrindusa88(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Return of the pg_wal issue..
Date: 2025-01-22 22:16:56
Message-ID: 6a22efea7f4649424d6b99d8223f261eec0f717e.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2025-01-22 at 17:33 +0000, Paul Brindusa wrote:
> So I want to try and get a solution for this and fix this issue with the pg_wal
> files filling up the drive at a ridiculous rate. I have been manually moving
> logs to a different directory but have had no luck in finding an actual solution.
>
> The cluster is a 3 node cluster with HA which is running wirth patroni.
>
> Please help me out, I will mention that I have test cluster spun up in case
> something needs testing. 
>
> Also want to give a shout out to Lorenz Albe's for posting stuff about wal
> files on his company blog.

I guess you are referring to
https://www.cybertec-postgresql.com/en/why-does-my-pg_wal-keep-growing/

I listed all the reasons I know for your predicament.
Did you do some research along these lines?
If yes, what did you find?

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2025-01-23 02:53:18 Re: Records count mismatch with logical replication
Previous Message Rich Shepard 2025-01-22 20:07:09 Re: Meaning of + symbol at end of column string