Postgres Pro
Downloads
Home   >   mailing lists

Re: PG_TERMINATE_BACKEND not working. - Mailing list pgsql-general

From Raghavendra
Subject Re: PG_TERMINATE_BACKEND not working.
Date
Msg-id CA+h6Ahja=5x+Afz7EUNJ6D-Gkzkz9W1K_=htQBidWiEiL_Xi-g@mail.gmail.com
Whole thread Raw
In response to Re: PG_TERMINATE_BACKEND not working.  (Harry <shirlekar.harshal@gmail.com>)
Responses Re: PG_TERMINATE_BACKEND not working.
List pgsql-general
Tree view
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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: High SYS CPU - need advise
Next
From: Achilleas Mantzios
Date:
Subject: Trigger based replication with ENABLE REPLICA triggers and session_replication_role best practice(s)