>> 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