PostgreSQL data volume fills overnight

On-call incidentHard40 min

Your task

A primary PostgreSQL instance's data volume fills to 100% at 04:00 and the database refuses writes (it shuts down to protect itself). Disk dashboards show steady growth on pg_wal/ over the last 12 hours specifically, table data size is flat. A read replica went offline for maintenance at 16:00 yesterday and never reconnected, and a logical replication slot for a downstream analytics CDC pipeline shows a replication-lag/slot-retained-bytes metric climbing all night. Normal table churn is unchanged. Triage and recover.

It covers

  • Wal
  • Replication lag
  • Postgres