Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
How does my new Postgres DB have maxed out connections immediately after creation?
I’m currently building a site, and it’s currently not being shared too widely.
Recently, I setup a new DB via postgres managed connections, did a pg_dump, and connected to it. I’ve done this a couple times so far, with no issues.
Immediately, the site crashed. A quick inspection showed that the DB connection was maxed out at 150 connections.
I’m not particularly great at DB management, tbh, this is my first project where I’ve worked on the whole stack. How does this happen? And how would I fix it? I was thinking of setting up a connection pool, but honestly I shouldn’t have anywhere near enough traffic to require a pool quite yet.