too-many-connections-for-database-postgres.mdx

Error in user YAML: (<unknown>): mapping values are not allowed in this context at line 1 column 27

---
title = "Database: \"Error: too many connections for database \"postgres\"\""
topics = [ "database" ]
keywords = []
---

When getting an error where your connections are overwhelmed Error: too many connections for database "postgres"

Why This Occurs: This issue occurs when datconnlimit gets modified. The default value for datconnlimit is -1. https://www.postgresql.org/docs/current/catalog-pg-database.html

To check and resolve:

1. Check the value for datconnlimit using the query below

   select datconnlimit from pg_database where datname='postgres';

   • If the value you see is 0 or any other value other than -1, proceed with the next step.

2. Update datconnlimit to DEFAULT

   ALTER DATABASE postgres CONNECTION LIMIT DEFAULT;