pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how 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>
  2007-08-20 21:21 ` Re: how to kill a Postgres connection on the list of select * from pg_stat_activity? Scott Marlowe <scott.marlowe@gmail.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 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>
  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