sorry, too many clients already error

From: Sandeep Gupta <gupta(dot)sandeep(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: sorry, too many clients already error
Date: 2017-05-16 22:28:40
Message-ID: CAAywg7tj6JGCn94hnr2fwjRU6-dw0=CO+wfr-keB9-WZUvsa7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have set max_connection = 40.

The usage is somewhat not typical. It is basically
experiment runs that connect to the database
and dump results there.

The experiments connect through JDBC and
they close the connection when they are done.

I can verify that no more than 20 clients/experiments
are active at any given time.

What could be the cause of the database issuing
too many clients error. Could I have set resources too high?

Thanks.
-sandeep

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-05-16 22:53:29 Re: sorry, too many clients already error
Previous Message Adrian Klaver 2017-05-16 17:46:43 Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2