Re: DB connection issue suggestions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.vf@xxxxxxxxx> wrote:


Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna <sudhir.guna.sg@xxxxxxxxx> 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux