Re: pg_wal folder high disk usage

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Thu, Oct 31, 2024 at 6:36 AM Paul Brindusa <paulbrindusa88@xxxxxxxxx> 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!