Getting error "too many clients already" despite having a db connection limit set

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.

Responses

Browse pgsql-general by date

  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