Feedback-ID: i76984098:Fastmail
Message-ID: <0ba329ef-62aa-4ab3-aefd-141baabced3b@aklaver.com>
Date: Wed, 22 Jan 2025 10:03:44 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Return of the pg_wal issue..
To: Paul Brindusa <paulbrindusa88@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/0ba329ef-62aa-4ab3-aefd-141baabced3b%40aklaver.com>
Precedence: bulk

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
> paulbrindusa88@gmail.com <mailto:paulbrindusa88@gmail.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com