| From: | Craig Ringer <craig(at)2ndQuadrant(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-18 11:25:41 |
| Message-ID: | 50A8C5B5.5080108@2ndQuadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/16/2012 02:34 PM, Harry wrote:
> I am facing problem i.e. connections after execution completed are residing
> in pg_stat_activity and pg_stat_database.
> but when i am trying to kill them manually using pg_terminate_backend (All
> IDLE connections are getting killed but, others like declare, select etc.)
> are not getting killed getting result false.
> Kindly help to resolve this issue.
More detail is needed.
Pg version?
OS and version?
Exact command output?
What the queries that're not terminated are doing?
Why you're terminating them / what problem you're trying to solve?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Angelico | 2012-11-18 11:48:51 | Re: PG_TERMINATE_BACKEND not working. |
| Previous Message | Vincent Veyron | 2012-11-18 09:21:17 | Re: user aggregate function ( calculate the average value of each index of an array column ) |