MIME-Version: 1.0
References: <CAFeSbqjySUzp_Q4XNR_ajnV84O=om0f5rzpjPsQaNitDkxXjHw@mail.gmail.com>
In-Reply-To: <CAFeSbqjySUzp_Q4XNR_ajnV84O=om0f5rzpjPsQaNitDkxXjHw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 31 Oct 2024 06:46:40 -0400
Message-ID: <CANzqJaBVwJG5nJbJMPdO4dDr0V234RDmOekXoWvyu3uCHJTjXg@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="00000000000040f9750625c389ab"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBVwJG5nJbJMPdO4dDr0V234RDmOekXoWvyu3uCHJTjXg%40mail.gmail.com>
Precedence: bulk

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

On Thu, Oct 31, 2024 at 6:36=E2=80=AFAM Paul Brindusa <paulbrindusa88@gmail=
.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.
>

Is data supposed to be replicated to a second (remote) database? Such
growth would be explained if that network link is broken.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Oct 31, 2024 at 6:36=E2=80=AFAM P=
aul Brindusa &lt;<a href=3D"mailto:paulbrindusa88@gmail.com">paulbrindusa88=
@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Good morning,</d=
iv><div><br></div><div>On one of our postgres instances we have the pg_wal/=
data folder up to 196GB, out of 200GB disk filled up.</div><div>This has st=
opped the posgresql.service this morning causing two applications to crash.=
</div><div>Unfortunately our database admin is on leave today, and we are t=
rying to figure out how to get the disk down?</div><div>Any ideas or sugges=
tions are more than welcome.</div></div></blockquote><div>=C2=A0</div></div=
>Is data supposed to be replicated to a second (remote) database? Such grow=
th would be explained if that network link is broken.<br clear=3D"all"><div=
><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D=
"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;,=
 and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div=
>&lt;Redacted&gt; crustacean!</div></div></div></div></div></div>

--00000000000040f9750625c389ab--