From: | Howard Cole <howardnews(at)selestial(dot)com> |
---|---|
To: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Killing a session in windows |
Date: | 2007-12-13 23:28:41 |
Message-ID: | 4761C029.9000602@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thomas H. wrote:
>>> wasn't the OP asking for a way to kill active connections to a db?
>>> afaik pgAdmin3 does provide this functionality:
>>>
>>> pgadmin3 > tools > server status
>>>
>>> there you can easily terminate connections & transactions to a
>>> particular db. works pretty well in my test, i can kill active
>>> connections and drop the db afterwards.
>>>
>>> regards,
>>> thomas
>> The pgadmin terminate connections never did anything on any of my
>> windows servers. I always assumed it was something geared towards nix
>> servers that never quite worked on windows???
>>
>
> i'm using the pgAdmin3 on windows 2003 and win32 pgsql 8.x for quite a
> while now, and the terminate feature has been working just fine a few
> times in the last years.
>
> - thomas
>
>
Hi Thomas,
Just tried it on my vista client machine. The "Terminate" button is
greyed out - I just have a cancel option. Maybe I am not using pgAdmin
right?
P.S. The "pg_ctl kill TERM" worked fine.
Howard.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2007-12-14 00:09:24 | Re: [GENERAL] Slow PITR restore |
Previous Message | Thomas H. | 2007-12-13 23:21:39 | Re: Killing a session in windows |