From: | Sudhir Guna <sudhir(dot)guna(dot)sg(at)gmail(dot)com> |
---|---|
To: | MichaelDBA Vitale <michaeldba(at)sqlexec(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: DB connection issue suggestions |
Date: | 2022-05-11 01:46:45 |
Message-ID: | CAGedWvNS9zo85UMweQC3ZE3LP=iRUHxY7BJKQFuCuFitAbmsbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi MichaelDBA,
Thank you for reviewing.
I had validated the show max_connections and its 1000.
[image: image.png]
Regards,
Guna
On Wed, May 11, 2022 at 2:13 AM MichaelDBA Vitale <michaeldba(at)sqlexec(dot)com>
wrote:
> Please show output of "show max_connections" to validate your assumptions.
>
> On 05/10/2022 12:59 PM Sudhir Guna <sudhir(dot)guna(dot)sg(at)gmail(dot)com> wrote:
>
>
> 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.
>
> Regards,
> Guna
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sudhir Guna | 2022-05-11 01:52:10 | Re: DB connection issue suggestions |
Previous Message | Sudhir Guna | 2022-05-11 01:44:59 | Re: DB connection issue suggestions |