Re: killing idle attaches without killing others

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: killing idle attaches without killing others
Дата
Msg-id 4C597B25.7070101@hogranch.com
обсуждение исходный текст
Ответ на killing idle attaches without killing others  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Список pgsql-general
  On 08/04/10 7:03 AM, Gauthier, Dave wrote:
>
> Hi:
>
> 8.3.4 on Linux
>
> How can one kill just the <IDLE> processes I see attached to a DB
> (from pg_stat_activity) without disturbing the others?  If I need to
> kill the idle pids one ata time, which signal_name should I use for that?
>
>

kill the programs that are making those idle connections.



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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: killing idle attaches without killing others
Следующее
От: Tom Lane
Дата:
Сообщение: Re: hashtable issue - HASH_FIND??