Code RoomPostgres WAL directory fills disk
HardPrep Room Coding #4536

Postgres WAL directory fills disk

On-callDatabases & SQLStorage & CDNSenior–Staff~35 min

At 01:10 your Postgres primary stops accepting writes: the app logs 'could not extend file ... No space left on device' and the database goes effectively read-only. df shows the data volume at 100%. The pg_wal directory has ballooned to hundreds of GB. You recently set up a new logical replication subscriber for an analytics pipeline, and that subscriber has been down for maintenance since yesterday afternoon. How do you triage, recover service, and prevent recurrence?

What a strong answer looks like

Stop the bleeding first (mitigate), then form hypotheses from real signals. Separate root cause from symptom, communicate status as you go, and close with what prevents a repeat.

0:00 of about 35 min
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.