Hi Ranier, We have tried to upgrade the postgresql- 42.3.5 .jarand unfortunately the issue still persists.
Regards, Guna On Wed, May 11, 2022 at 9:44 AM Sudhir Guna <sudhir.guna...@gmail.com> wrote: > 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 >> >