BUG #14708: Frequent connection timeout issue while connecting to Postgres database

From: ruchitat(at)planittesting(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14708: Frequent connection timeout issue while connecting to Postgres database
Date: 2017-06-15 11:14:18
Message-ID: 20170615111418.1435.5692@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14708
Logged by: Ruchita Terse
Email address: ruchitat(at)planittesting(dot)com
PostgreSQL version: 9.6.1
Operating system: Windows
Description:

In our database setup we are often encounter wiht the connection timeout
issue while connecting with external application. Please find the detailed
information below.

While server trying to connect Postgres database we are getting following
error message :
1. FATAL: cancelling authentication due to timeout.
2. FATAL : two many clients already.

Even the number of actual connected clients is very minimum. The
maximum limit set for connection of clients is 200 and also currently
utilized connections are not more than 50 i.e not exceeding default
connection limit.

PS: We are connecting with port 5432

Kindly help us to resolve this issue.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-06-15 13:20:35 Re: BUG #14706: Dependencies not recorded properly for base types
Previous Message Rohit Dwivedi 2017-06-15 10:43:13 Regarding copy of function from one db to another db