79768209

Date: 2025-09-18 09:07:18
Score: 1
Natty:
Report link

Late answer, but looks like there are multiple possible reasons why the storage grows steadily. Orphan replication slots created for all-tables publications pile up WAL content when the replica suddenly goes offline or idle. Also idle or low-writing databases cause "WAL jams". I have experienced a similar situation but using an AWS RDS Postgres as master, which comes with some hidden spice: heartbeat transactions. This blog describes nicely other cases: https://wolfman.dev/posts/pg-logical-heartbeats/

So, avoid:

To drop a replica slot use:

SELECT pg_drop_replication_slot('replication_name');
CHECKPOINT;
Reasons:
  • Blacklisted phrase (1): This blog
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Ronal Douglas