From: | Chris Angelico <rosuav(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG_TERMINATE_BACKEND not working. |
Date: | 2012-11-18 11:48:51 |
Message-ID: | CAPTjJmqJRmFCDyQM4TpaHfkub5d0_1RwkMYrhcTtCsCwm75iqA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Nov 18, 2012 at 10:25 PM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
> 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?
And: Are you logged in as superuser when you try to kill them, and if
not, are the other sessions from your own user?
ChrisA
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-11-18 12:34:46 | Re: Parser - Query Analyser |
Previous Message | Craig Ringer | 2012-11-18 11:25:41 | Re: PG_TERMINATE_BACKEND not working. |