pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: MichaelDBA Vitale <michaeldba@sqlexec.com>
To: Sudhir Guna <sudhir.guna.sg@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: DB connection issue suggestions
Date: Tue, 10 May 2022 14:13:14 -0400 (EDT)
Message-ID: <1050815421.2743544.1652206394232@email.ionos.com> (raw)
In-Reply-To: <CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com>
References: <CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com>

<!doctype html>
<html>
 <head> 
  <meta charset="UTF-8"> 
 </head>
 <body>
  <div>
   Please show output of "show max_connections" to validate your assumptions.
  </div>
  <blockquote type="cite">
   <div>
    On 05/10/2022 12:59 PM Sudhir Guna &lt;sudhir.guna.sg@gmail.com&gt; wrote:
   </div>
   <div>
    <br>
   </div>
   <div>
    <br>
   </div>
   <div dir="ltr">
    <div>
     Dear All,
    </div>
    <div>
     <br>
    </div>
    <div>
     We have recently upgraded Postgresql 9.4 standalone server to Postgresql 11.2 with High Availability (2 servers : Master and Standby).
    </div>
    <div>
     <br>
    </div>
    <div>
     While trying to test using ETL applications and reports, we observe that the ETL jobs fails with below error,
    </div>
    <div>
     <br>
    </div>
    <div>
     2022/05/06 16:27:36 - Error occurred while trying to connect to the database
     <br>2022/05/06 16:27:36 - Error connecting to database: (using class org.postgresql.Driver)
     <br>2022/05/06 16:27:36 - FATAL: Sorry, too many clients already
    </div>
    <div>
     <br>
    </div>
    <div>
     We have increased the<code> max_connections = 1000 in postgresql.conf file.</code>
    </div>
    <div>
     <code><br></code>
    </div>
    <div>
     <code>It worked ok for a day and later we get the same error message.</code>
    </div>
    <div>
     <code><br></code>
    </div>
    <div>
     <code>Please help to advise on any additional settings required. The prior Postgresql 9.4 had the default <code>max_connections = 100</code> and the applications worked fine.</code>
    </div>
    <div>
     <code><br></code>
    </div>
    <div>
     <code>Regards,</code>
    </div>
    <div>
     <code>Guna</code>
    </div>
   </div>
  </blockquote>
 </body>
</html>

view thread (14+ messages)  latest in thread

Message-ID: <1050815421.2743544.1652206394232@email.ionos.com>
Permalink:  ../1050815421.2743544.1652206394232@email.ionos.com/
Also on:    postgresql.org/message-id/1050815421.2743544.1652206394232@email.ionos.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: michaeldba@sqlexec.com, sudhir.guna.sg@gmail.com
  Subject: Re: DB connection issue suggestions
  In-Reply-To: <1050815421.2743544.1652206394232@email.ionos.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox