Re: PG_TERMINATE_BACKEND not working.

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: Raw Message | Whole Thread | 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/

In response to

Responses

Browse pgsql-general by date

  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