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