Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] sorry, too many clients already error - Mailing list pgsql-general

From Sandeep Gupta
Subject [GENERAL] sorry, too many clients already error
Date
Msg-id CAAywg7tj6JGCn94hnr2fwjRU6-dw0=CO+wfr-keB9-WZUvsa7w@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] sorry, too many clients already error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round4 - compilation issues on RHEL 7.2
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] sorry, too many clients already error