On 8/20/07, Jessica Richard <[EMAIL PROTECTED]> wrote: > Sometime a script talking to the Postgres has already been killed on the OS > level, but the Postgres for this script is still listed out of select * from > pg_stat_activity, saying a particular database is still being accessed by > this script. > > How to kill (release) this connection in this case? >
see http://www.postgresql.org/docs/8.2/static/functions-admin.html sepcifically pg_cancel_backend(pid) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
