Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1noUML-0005rQ-VT
	for pgsql-performance@arkaria.postgresql.org; Tue, 10 May 2022 18:13:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1noUMK-0008G6-SI
	for pgsql-performance@arkaria.postgresql.org; Tue, 10 May 2022 18:13:20 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <michaeldba@sqlexec.com>)
	id 1noUMK-0008FE-Hn
	for pgsql-performance@lists.postgresql.org; Tue, 10 May 2022 18:13:20 +0000
Received: from mout.perfora.net ([74.208.4.194])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <michaeldba@sqlexec.com>)
	id 1noUMI-00038w-CV
	for pgsql-performance@postgresql.org; Tue, 10 May 2022 18:13:20 +0000
Received: from oxuslxaltgw05.schlund.de ([10.72.76.61]) by mrelay.perfora.net
 (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0Lt0Wa-1nuQPg3sLK-012cCb;
 Tue, 10 May 2022 20:13:14 +0200
Date: Tue, 10 May 2022 14:13:14 -0400 (EDT)
From: MichaelDBA Vitale <michaeldba@sqlexec.com>
To: Sudhir Guna <sudhir.guna.sg@gmail.com>, pgsql-performance@postgresql.org
Message-ID: <1050815421.2743544.1652206394232@email.ionos.com>
In-Reply-To: 
 <CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com>
References: 
 <CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com>
Subject: Re: DB connection issue suggestions
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Priority: 3
Importance: Normal
X-Mailer: Open-Xchange Mailer v7.10.5-Rev41
X-Originating-Client: open-xchange-appsuite
X-Provags-ID: V03:K1:fkjn2J1f4NZbIFRJakq6lffyYA7txZonvBPh0H8nercs6gMeIyU
 8T/0OCvOf34Cz8M82nSeAQBzWfnEbvFZ4D0ERuK6BLrX6bCylzXazhLcgH+QsfSyMwTnrYJ
 TXae8v+r0Nhi+fCwZaUpL7lUdY0BnwdIShGX3EA8bnY3vVTHjeR6OYon1pjoZHv9qxHlWG5
 HJq6XL+gkl+ZU2XlE1Hzw==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:sNh0MmZ5zRU=:2oQr2AyWG5nFsmJK22raKk
 /Lim8BmjmsZQyZSN4aLVUbXJroOmu9bZNnlimxN8pNq67UrbL/QQ8MtFc733aTlz1gsHzhHHH
 7mQXNDCCZApnmLWUvkqeiIWqEH21bFwXDqM+LVvWQL7a7OsAdzhmvTdAqxVBaXtJ1p6aFrUjt
 HiD9i7DgfVYRLy/iWKz5vtO6L+Axm6b+1vqnBMLvzTTxkUOdzOEeeGUZSfAiaWsMrLR9O8GPf
 j7lPvPy2FeLIPPltsoWMs8rZbbDxvg4LoF6lmNNeWI39CCbWRhlpwtkAOXdBIwNSfBX5mmH28
 bady+01h+/x2LODQpJWDxfDvwuG6ln2FUGOBW2ytvaNVElmUMI9iSwVGPYVMMJ19sq6/VWGCR
 iZmjml1rHYrw41shrAZbgL9sIUJENRkG+z+B2LXUaFthpUpIHO6P7n3Jlcd2L6Zcg2FeJEv+U
 HrokyLBKXcM8BzoyivRJ188P4hWqAvxJ9A9StY674o0m70Hpw2zzlFyUZwaxxJsCgnww5erZb
 YihleS/vCMtHBHiqIH7cglWt9OFh6rNe1jwMSJ58Ea7hrvpMSjz23hE0xX7yP7W8NCHwQdIgO
 XzC/n+hauGbp5tBKi/HIkzWSmJdB7KwwX0pfKaM8E9gGmeX11gU25KqmK310txOdmKhSCmoYv
 fH07JE9BNs8iow5FfBhSrZ5kHjzN+JXnYFVTSssYTbEmWK7lHiWb14QKi6Ab1ERCOo3nAHhAi
 Fi230EttsdSf4bF0
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/1050815421.2743544.1652206394232%40email.ionos.com>
Precedence: bulk

<!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>