Thread: BUG #15661: Error connecting to the server

BUG #15661: Error connecting to the server

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      15661
Logged by:          ZRIRAK YOUSSEF
Email address:      youssef.zrirak@yazaki-europe.com
PostgreSQL version: 9.4.0
Operating system:   windows server 2012 R2
Description:

Hello
we had faced many type this type of message ( Error connecting to the server
:Fatal: too many clients already )

could you please support in this subject

Many thanks


Re: BUG #15661: Error connecting to the server

From
"David G. Johnston"
Date:
On Thu, Feb 28, 2019 at 3:22 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      15661
> Logged by:          ZRIRAK YOUSSEF
> Email address:      youssef.zrirak@yazaki-europe.com
> PostgreSQL version: 9.4.0
> Operating system:   windows server 2012 R2
> Description:
>
> Hello
> we had faced many type this type of message ( Error connecting to the server
> :Fatal: too many clients already )
>
> could you please support in this subject

This is not a bug.  You either need to increase max_connections or
decrease the number of simultaneous connections.

David J.

p.s. if you didn't just choose a version randomly you really need to
put "updating and upgrading PostgreSQL" into the list of DBA tasks
that your system needs performed regularly.


Re: BUG #15661: Error connecting to the server

From
"Guy Rouillier"
Date:
On 2/28/2019 3:42:19 AM, "PG Bug reporting form" <noreply@postgresql.org> wrote:

The following bug has been logged on the website:
 
Bug reference: 15661
Logged by: ZRIRAK YOUSSEF
Email address: youssef.zrirak@yazaki-europe.com
PostgreSQL version: 9.4.0
Operating system: windows server 2012 R2
Description:
 
Hello
we had faced many type this type of message ( Error connecting to the server
:Fatal: too many clients already )
 
could you please support in this subject
 
Many thanks
 
Check your postgresql.conf configuration file.  Specifically, look at the section headed "CONNECTIONS AND AUTHENTICATION".  Default max_connections = 100.  You provide no information to go on regarding your environment, other than your server being Windows Server 2012, so we don't know what type of clients you are using.  The default value is typically enough; if you are exceeding that on a regular basis, chances are your clients are failing to release their connections when finished.  You *could* just increase your max_connections value, but without understanding your client environment, this is not a good general solution.  Each client connection consumes resources, so you don't want to just blindly allow a large number of connections.  Ideally, you'd like your clients to connect just long enough to execute a business transaction and then immediately disconnect; connection pools allow this to be done efficiently.

--
Guy Rouillier