<!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 <sudhir(dot)guna(dot)sg(at)gmail(dot)com> 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>