public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[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 10:03:44 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
References: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
On 1/22/25 09:33, Paul Brindusa wrote:
> Good afternoon,
>
> Following below we are facing a similar issue and im getting a real buzz
> to get this working myself, speaking to my DBA in the company has
> actually left me a bit cold as he is not good with postgres.
>
> 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.
>
> Again any help will be greatly appreciated.
A good deal more information is needed to troubleshoot this:
1) Postgres version(s).
2) The Patroni version.
3) The Patroni configuration.
4) Definition of 'ridiculous rate'.
5) Relevant information from the logs.
>
>
> " On one of our postgres instances we have the pg_wal/data folder up to
> 196GB, out of 200GB disk filled up.
> This has stopped the posgresql.service this morning causing two
> applications to crash.
> Unfortunately our database admin is on leave today, and we are trying to
> figure out how to get the disk down?
> Any ideas or suggestions are more than welcome.
>
> Thank you in advance."
>
>
> --
> Kind Regards,
> Paul Brindusa
> [email protected] <mailto:[email protected]>
>
--
Adrian Klaver
[email protected]
view thread (5+ messages) latest in thread
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