BUG #15661: Error connecting to the server

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.

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