| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | Harry <shirlekar(dot)harshal(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG_TERMINATE_BACKEND not working. |
| Date: | 2012-11-20 07:21:43 |
| Message-ID: | CA+h6Ahja=5x+Afz7EUNJ6D-Gkzkz9W1K_=htQBidWiEiL_Xi-g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
n Mon, Nov 19, 2012 at 10:52 AM, Harry <shirlekar(dot)harshal(at)gmail(dot)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
Blog: http://raghavt.blogspot.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2012-11-20 07:52:20 | Trigger based replication with ENABLE REPLICA triggers and session_replication_role best practice(s) |
| Previous Message | Welty, Richard | 2012-11-20 04:05:02 | Re: Experiences with pl/Java |