Re: Connection exceeded alert.

Please check maximum connection / Session parameter in postgreSQL.conf
file and you can increase maximum session/connection.

Please also check locking on database.

2024년 8월 6일 (화) 오전 9:32, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>님이 작성:

> Hi all,
>
> I have been trying to find a steps or solution for past 1 year once we
> received a connection exceeded alert. Couldn't get any answer from anybody
> or internet so far.
>
> Today I checked a pgbadger report and matched the timeline and found
> that, at that time of sudden connection hike (not normal), there were 3
> queries running at that time (2 update queries on table a , took 5s each,
> one insert query on table b which took 2.5mns).
>
> Anybody provide me steps what all I have to do 1. At that time of
> connection hike 2. If I am been asked to check after sometime as connection
> dropped to analyse.
>

--
*Muhammad Waqas*
*Senior Technical Support Engineer - Tech Support Center (Karachi)*
Mobile: +92-322-2844150
Email: *waqas(dot)m(at)bitnine(dot)net <waqas(dot)m(at)bitnine(dot)net>*
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.