MIME-Version: 1.0
From: Paul Brindusa <paulbrindusa88@gmail.com>
Date: Wed, 22 Jan 2025 17:33:37 +0000
Message-ID: <CAFeSbqh0Mj3bm9+aCaz5g4NhKn8+t4aGF=p5vOPc5oVssveATQ@mail.gmail.com>
Subject: Return of the pg_wal issue..
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006e076d062c4ee59a"
Archived-At: <https://www.postgresql.org/message-id/CAFeSbqh0Mj3bm9%2BaCaz5g4NhKn8%2Bt4aGF%3Dp5vOPc5oVssveATQ%40mail.gmail.com>
Precedence: bulk

--0000000000006e076d062c4ee59a
Content-Type: text/plain; charset="UTF-8"

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.


" 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

--0000000000006e076d062c4ee59a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Good afternoon,</div><div><br></div><div>Followi=
ng below we are facing a similar issue and im getting a real buzz to get th=
is working myself, speaking to my DBA=C2=A0 in the=C2=A0 company has actual=
ly left me a bit cold as he is not good with postgres.</div><div><br></div>=
<div>So I want to try and get a solution for this and fix this issue with t=
he pg_wal files filling up the drive at a ridiculous rate. I have been manu=
ally moving logs to a different directory but have had no luck in finding a=
n actual solution.<br></div><div><br></div><div>The cluster is a 3 node clu=
ster with HA which is running wirth patroni.</div><div><br></div><div>Pleas=
e help me out, I will mention that I have test cluster spun up in case some=
thing needs testing.=C2=A0</div><div><br></div><div>Also want to give a sho=
ut out to Lorenz Albe&#39;s for posting stuff about wal files on his compan=
y blog.</div><div><br></div><div>Again any help will be greatly appreciated=
.</div><div><br></div><div><br></div><div>&quot; On one of our postgres ins=
tances we have the pg_wal/data folder up to 196GB, out of 200GB disk filled=
 up.</div><div>This has stopped the posgresql.service this morning causing =
two applications to crash.</div><div>Unfortunately our database admin is on=
 leave today, and we are trying to figure out how to get the disk down?</di=
v><div>Any ideas or suggestions are more than welcome.<br></div><div>=C2=A0=
<br></div><div>Thank you in advance.&quot;=C2=A0<font color=3D"#888888"><br=
></font></div><font color=3D"#888888"><div><div><div><div><br class=3D"gmai=
l-Apple-interchange-newline"></div></div></div></div></font></div><div><br>=
</div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr"=
 class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"l=
tr"><div>Kind Regards,</div><div>Paul Brindusa</div><div><a href=3D"mailto:=
paulbrindusa88@gmail.com" target=3D"_blank">paulbrindusa88@gmail.com</a></d=
iv><div><br></div></div></div></div>

--0000000000006e076d062c4ee59a--