Hi MichaelDBA, Thank you for reviewing.
I had validated the show max_connections and its 1000. [image: image.png] Regards, Guna On Wed, May 11, 2022 at 2:13 AM MichaelDBA Vitale <michael...@sqlexec.com> wrote: > Please show output of "show max_connections" to validate your assumptions. > > On 05/10/2022 12:59 PM Sudhir Guna <sudhir.guna...@gmail.com> 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 > >
