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
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 :)
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×