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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
