Re: PostgreSQL: Number of waiting connections too high

Поиск
Список
Период
Сортировка
От Holger Jakobs
Тема Re: PostgreSQL: Number of waiting connections too high
Дата
Msg-id cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com
обсуждение исходный текст
Ответ на PostgreSQL: Number of waiting connections too high  (Atul Kumar <akumar14871@gmail.com>)
Ответы Re: PostgreSQL: Number of waiting connections too high
Список pgsql-admin

Hi,

TCP maintains a backlog of waiting connections if a server application doesn't accept or deny connections.

PostgreSQL has a setting max_connections, so it won't accept any more.

So there are two solutions:

  • Lower the number of concurrent clients
  • Increase the max_connections setting in postgresql.conf

Regards,

Holger

Am 15.12.20 um 10:15 schrieb Atul Kumar:
HI,

I have postgres with 11.8 version.

I am getting below error of
PostgreSQL: Number of waiting connections too high.

Please help me in solving this situation.



Regards,
Atul


-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Atul Kumar
Дата:
Сообщение: PostgreSQL: Number of waiting connections too high
Следующее
От: Atul Kumar
Дата:
Сообщение: Re: PostgreSQL: Number of waiting connections too high