Re: pg_wal folder high disk usage - Mailing list pgsql-general

From Ron Johnson
Subject Re: pg_wal folder high disk usage
Date
Msg-id CANzqJaBVwJG5nJbJMPdO4dDr0V234RDmOekXoWvyu3uCHJTjXg@mail.gmail.com
Whole thread Raw
In response to pg_wal folder high disk usage  (Paul Brindusa <paulbrindusa88@gmail.com>)
List pgsql-general
On Thu, Oct 31, 2024 at 6:36 AM 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.

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

pgsql-general by date:

Previous
From: Paul Brindusa
Date:
Subject: pg_wal folder high disk usage
Next
From: Priancka Chatz
Date:
Subject: Re: pg_wal folder high disk usage