Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: how to kill a Postgres connection on the list of select * from pg_stat_activity?
- From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "Jessica Richard" <rjessil(at)yahoo(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: how to kill a Postgres connection on the list of select * from pg_stat_activity?
- Date: Mon, 20 Aug 2007 16:21:49 -0500
On 8/20/07, Jessica Richard <rjessil(at)yahoo(dot)com> 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)
- References:
- how to kill a Postgres connection on the list of select * from pg_stat_activity?
- From: Jessica Richard
- how to kill a Postgres connection on the list of select * from pg_stat_activity?
- Prev by Date: how to kill a Postgres connection on the list of select * from pg_stat_activity?
- Next by Date: After adjusting checkpoint related entries in postgresql.conf...
- Previous by thread: how to kill a Postgres connection on the list of select * from pg_stat_activity?
- Next by thread: After adjusting checkpoint related entries in postgresql.conf...
- Indexes: