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