Re: PG_TERMINATE_BACKEND not working.

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: PG_TERMINATE_BACKEND not working.
Дата
Msg-id CA+h6Ahja=5x+Afz7EUNJ6D-Gkzkz9W1K_=htQBidWiEiL_Xi-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG_TERMINATE_BACKEND not working.  (Harry <shirlekar.harshal@gmail.com>)
Ответы Re: PG_TERMINATE_BACKEND not working.  (dinesh kumar <dineshkumar02@gmail.com>)
Список pgsql-general
Дерево обсуждения
n Mon, Nov 19, 2012 at 10:52 AM, Harry <shirlekar.harshal@gmail.com> wrote:
Chris Yes, i am logging in as Super User also, other side same user's
connection(Superuser) i am trying to kill.


Can you give a try, by picking the IP's of the processes which are not getting killed from pg_stat_activity(client_addr column) and make REJECT entries in pg_hba.conf file as below:

host   all   all  <client_addr IP>   reject

and reload the cluster using pg_ctl -D $PGDATA reload

Now try killing the process 

pg_ctl kill TERM  <Process PID>

---
Regards,
Raghavendra
EnterpriseDB Corporation

 

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: High SYS CPU - need advise
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Trigger based replication with ENABLE REPLICA triggers and session_replication_role best practice(s)