The Case of the 79 Idle Connections
It started with a message from the DBA team. Our shared Postgres host was carrying 79 idle connections from a single service, ours, and they were capping our role at 20 until we sorted it out. By the time I read it, things were already worse: a database migration wouldn’t even start. FATAL: too many connections for role. Our own app pods had eaten the entire allowance, leaving nothing for the migration that was supposed to fix things. We were locked out of our own database by ourselves.



