public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Paul Brindusa <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Return of the pg_wal issue..
Date: Wed, 22 Jan 2025 23:16:56 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
References: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>

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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Return of the pg_wal issue..
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox