From: | adolfo flores <adolfoflores2211(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Getting error "too many clients already" despite having a db connection limit set |
Date: | 2025-06-16 16:29:28 |
Message-ID: | CADM4kyuO39mr8E_xDw4GGi2v9gCK0dq52fKj40FcsXJeKxgRrA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Team,
I hope you can help me with an issue we're experiencing. We have an app
running on Kubernetes that opens a huge number of connections within a
couple of seconds.
The database that the app connects to, is configured with a connection
limit of 30% of the max_connections setting. Despite this limit being set
for that database, we're seeing the following errors in the PostgreSQL logs:
FATAL: sorry, too many clients already
FATAL: remaining connection slots are reserved for roles with the
SUPERUSER attribute
Is it expected behavior to reach the max_connections limit when that app
opens many connections in a short period of time, even if a connection
limit is set for that database and everything else uses no more than 10% of
the max_connections?
Or any idea on what could be happening?
Regards.
Adolfo F.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2025-06-16 16:39:09 | Re: Getting error "too many clients already" despite having a db connection limit set |
Previous Message | Rachel Roch | 2025-06-16 13:52:26 | Re: pg_restore ERROR: permission denied to change default privileges |