pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to kill a Postgres connection on the list of select * from pg_stat_activity?
2+ messages / 2 participants
[nested] [flat]
* how to kill a Postgres connection on the list of select * from pg_stat_activity?
@ 2007-08-20 20:40 Jessica Richard <rjessil@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jessica Richard @ 2007-08-20 20:40 UTC (permalink / raw)
To: pgsql-admin
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?
Thanks!!!
---------------------------------
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how to kill a Postgres connection on the list of select * from pg_stat_activity?
@ 2007-08-20 21:21 Scott Marlowe <scott.marlowe@gmail.com>
parent: Jessica Richard <rjessil@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2007-08-20 21:21 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
On 8/20/07, Jessica Richard <rjessil@yahoo.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)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-08-20 21:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-20 20:40 how to kill a Postgres connection on the list of select * from pg_stat_activity? Jessica Richard <rjessil@yahoo.com>
2007-08-20 21:21 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox