Hi Ranier, Thank you for reviewing this.
Yes this is Pentaho and SSRS application. We are currently using postgresql-42.2.4.jar currently. Regards, Guna On Wed, May 11, 2022 at 2:55 AM Ranier Vilela <ranier...@gmail.com> wrote: > > > Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna < > sudhir.guna...@gmail.com> escreveu: > >> 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. >> > I guess that ETL is pentaho? > You can try to use the latest JDBC driver (42.3.5) . > > regards, > Ranier Vilela >