How does my new Postgres DB have maxed out connections immediately after creation?

Posted May 28, 2020 421 views
PostgreSQLDigitalOcean Managed PostgreSQL Database

Hey so,

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.

Any help?

edited by AHA
Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!