Manage PostgreSQL Error: remaining connection slots are reserved for non-replication superuser connections. sorry, too many clients already

I explored DigitalOceans Managed Databases particularly PostgreSQL as a means to simplify development and save time although I found that very frequently there would be the following error:

Error: remaining connection slots are reserved for non-replication superuser connections. sorry, too many clients already

I noticed that this error would occur quite frequently regardless of what was invoking the database for example as to whether a tool like DataGrip / PgAdmin were being used or the backend server. At first I thought it was related to the backend server until I started getting the error within DataGrip additionally.

We’re using Strapi and PostgreSQL, with 3 developers working on this simultaneously.

I’ve explored using connection pooling although have had the following error with both database tool and server:

cross database references are not implemented

I’ve now explored creating and hosting my own PostgreSQL database on a DigitalOcean Ubuntu droplet and the error no longer seems to occur.

So whilst I’ve found a solution or workaround, I am interested as to why this error occurs with DigitalOcean Managed PostgreSQL Database.

Thanks for your help :)

Michael