From: | Anbazhagan M <anbazhagan(dot)m(at)instaclustr(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | Sudhir Guna <sudhir(dot)guna(dot)sg(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: DB connection issue suggestions |
Date: | 2022-05-11 06:30:52 |
Message-ID: | 16E9E3F0-E670-4708-A764-DE8EDFD79504@instaclustr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Dear team,
Can you confirm whether, post upgrade activity, all the post-upgrade steps including stats update on all the relations is complete. Upgrade doesn’t carry over the stats to the new upgraded cluster.
Regards,
Anbazhagan M
> On 11-May-2022, at 11:43 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> On Wed, 2022-05-11 at 00:59 +0800, Sudhir Guna wrote:
>> 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 = 100and the applications worked fine.
>
> Some application that uses the database has a connection leak: it opens new connections
> without closing old ones. Examine "pg_stat_activity" to find out which application is
> at fault, and then go and fix that application.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sudhir Guna | 2022-05-11 07:11:53 | Re: DB connection issue suggestions |
Previous Message | Laurenz Albe | 2022-05-11 06:13:04 | Re: DB connection issue suggestions |