Message-ID: <6a22efea7f4649424d6b99d8223f261eec0f717e.camel@cybertec.at>
Subject: Re: Return of the pg_wal issue..
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Paul Brindusa <paulbrindusa88@gmail.com>, pgsql-general
	 <pgsql-general@postgresql.org>
Date: Wed, 22 Jan 2025 23:16:56 +0100
In-Reply-To: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
References: 
	<CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/6a22efea7f4649424d6b99d8223f261eec0f717e.camel%40cybertec.at>
Precedence: bulk

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 mov=
ing
> logs to a different directory but have had no luck in finding an actual s=
olution.
>=20
> The cluster is a 3 node cluster with HA which is running wirth patroni.
>=20
> Please help me out, I will mention that I have test cluster spun up in ca=
se
> something needs testing.=C2=A0
>=20
> Also want to give a shout out to Lorenz Albe's for posting stuff about wa=
l
> 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