Re: Deleting idle connections

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: Deleting idle connections
Дата	25 февраля 02:05:44
Msg-id	CAKFQuwabejBgxy0R3715SuuT0V+dK7_VPUKUcw0eznN8HtCFPw@mail.gmail.com обсуждение исходный текст
Ответ на	Deleting idle connections (Yongye Serkfem <yserkfem@gmail.com>)
Список	pgsql-general

On Mon, Feb 24, 2025 at 3:50 PM Yongye Serkfem <yserkfem@gmail.com> wrote:

I am having a series of idle connections and unable to delete them with a single command. Any help in realizing this would be greatly appreciated.

"deleting" really isn't the word used to describe this, terminate, kill, or disconnect would be better choices.

You should be able to just use pg_terminate_backend in a select query to accomplish your goal.

Though usually you are better off fixing the problem at the source; or use something like pgbouncer.

David J.

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