Is there a way to kill a connection from the pg_stat_activitly list?

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Is there a way to kill a connection from the pg_stat_activitly list?
Date: 2007-10-15 12:56:06
Message-ID: 23085.65196.qm@web56403.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

When you see a hanging Postgres connection (or a job running so long and you don't want to continue any more) from

select * from pg_stat_activity

and you want to disconnect it,

how do you do it?

thanks,
Jessica


---------------------------------
Check out the hottest 2008 models today at Yahoo! Autos.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kenneth Marshall 2007-10-15 13:04:13 Re: How to update from 8.1 to 8.2 ?
Previous Message Alexander Kuprijanov 2007-10-15 12:52:43 Re: How to update from 8.1 to 8.2 ?