From: | Sudhir Guna <sudhir(dot)guna(dot)sg(at)gmail(dot)com> |
---|---|
To: | Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: DB connection issue suggestions |
Date: | 2022-05-11 01:44:59 |
Message-ID: | CAGedWvOOuKrukDfOS5zywBcTnCfhrjVK_4680kERG4WahzM+3g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sudhir Guna | 2022-05-11 01:46:45 | Re: DB connection issue suggestions |
Previous Message | Ranier Vilela | 2022-05-10 18:54:53 | Re: DB connection issue suggestions |