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.