On Wed, Jun 29, 2016 at 8:36 AM, Sachin Kotwal <kotsac...@gmail.com> wrote: > postgresql does not give any error. > > pgbench says: > client 36 aborted in state 2: ERROR: could not connect to server "server_1" > DETAIL: FATAL: sorry, too many clients already
The error message that you are seeing there "FATAL: sorry, too many clients already" is coming from the server. pgbench is just reporting the error which the server has sent to it. Now, it is impossible for me to know why the server is out of connections, but a likely cause is that you haven't set max_connections high enough. If there is some other cause, you haven't provided enough information to diagnose it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers