Re: DB connection issue suggestions

Sudhir Guna <sudhir.guna.sg@xxxxxxxxx> · Wed, 11 May 2022 09:46:45 +0800

Hi MichaelDBA,

Thank you for reviewing.

I had validated the show max_connections and its 1000.

Regards,
Guna

On Wed, May 11, 2022 at 2:13 AM MichaelDBA Vitale <michaeldba@xxxxxxxxxxx> wrote:

   Please show output of "show max_connections" to validate your assumptions.

    On 05/10/2022 12:59 PM Sudhir Guna <sudhir.guna.sg@xxxxxxxxx> wrote:

     Dear All,

     We have recently upgraded Postgresql 9.4 standalone server to Postgresql 11.2 with High Availability (2 servers : Master and Standby).

     While trying to test using ETL applications and reports, we observe that the ETL jobs fails with below error,

     2022/05/06 16:27:36 - Error occurred while trying to connect to the database

2022/05/06 16:27:36 - Error connecting to database: (using class org.postgresql.Driver)

2022/05/06 16:27:36 - FATAL: Sorry, too many clients already

     We have increased the max_connections = 1000 in postgresql.conf file.

     It worked ok for a day and later we get the same error message.

     Please help to advise on any additional settings required. The prior Postgresql 9.4 had the default max_connections = 100 and the applications worked fine.

     Regards,

     Guna