MIME-Version: 1.0
References: <CAFeSbqjySUzp_Q4XNR_ajnV84O=om0f5rzpjPsQaNitDkxXjHw@mail.gmail.com>
In-Reply-To: <CAFeSbqjySUzp_Q4XNR_ajnV84O=om0f5rzpjPsQaNitDkxXjHw@mail.gmail.com>
From: Priancka Chatz <pc9926@gmail.com>
Date: Thu, 31 Oct 2024 11:48:08 +0100
Message-ID: <CANnOdgbcUUgq3LxnyxNwf-7587HvGizO-zRMR2ZUZXWXtSLp=w@mail.gmail.com>
Subject: Re: pg_wal folder high disk usage
To: Paul Brindusa <paulbrindusa88@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000085507b0625c38ef4"
Archived-At: <https://www.postgresql.org/message-id/CANnOdgbcUUgq3LxnyxNwf-7587HvGizO-zRMR2ZUZXWXtSLp%3Dw%40mail.gmail.com>
Precedence: bulk

--00000000000085507b0625c38ef4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

You might wanna check if archive backups(id enabled) are happening and/or
if there is replication lag or replication broken if you have replicas.

On Thu, Oct 31, 2024 at 11:36=E2=80=AFAM Paul Brindusa <paulbrindusa88@gmai=
l.com>
wrote:

> Good morning,
>
> 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
>
>

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

<div dir=3D"ltr">Hi,<div><br></div><div>You might wanna check if archive ba=
ckups(id enabled) are happening and/or if there is replication lag or repli=
cation broken if you have replicas.=C2=A0</div></div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Oct 31, 2024 at 11:3=
6=E2=80=AFAM Paul Brindusa &lt;<a href=3D"mailto:paulbrindusa88@gmail.com">=
paulbrindusa88@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><div dir=3D"ltr"><div>Good morning,</div><div><br><=
/div><div>On one of our postgres instances we have the pg_wal/data folder u=
p to 196GB, out of 200GB disk filled up.</div><div>This has stopped the pos=
gresql.service this morning causing two applications to crash.</div><div>Un=
fortunately our database admin is on leave today, and we are trying to figu=
re out how to get the disk down?</div><div>Any ideas or suggestions are mor=
e than welcome. <br></div><div>=C2=A0<br></div><div>Thank you in advance.<b=
r></div><div><div><div><div><div><br><span class=3D"gmail_signature_prefix"=
>-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">=
<div>Kind Regards,</div><div>Paul Brindusa</div><div><a href=3D"mailto:paul=
brindusa88@gmail.com" target=3D"_blank">paulbrindusa88@gmail.com</a></div><=
div><br></div></div></div></div></div></div></div></div></div>
</blockquote></div>

--00000000000085507b0625c38ef4--