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) .