Re: DB connection issue suggestions

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(dot)guna(dot)sg(at)gmail(dot)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(dot)vf(at)gmail(dot)com> wrote:
>
>>
>>
>> Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna <
>> sudhir(dot)guna(dot)sg(at)gmail(dot)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
>>
>