From: Thomas F.O'Connell <tfo@sitening.com>
To: Ken Reid <Ken@homegain.com>
Cc: PGSQL Admin <pgsql-admin@postgresql.org>
Subject: Killing Processes
Date: Sat, 23 Apr 2005 10:58:46 -0500
Message-ID: <399c5204777051febd1e3432d981b03b@sitening.com> (raw)
In-Reply-To: <C0F6DD0E8F3B9040A77F857FCFAC452A01A3E05C@homegain1.homegain.com>
References: <C0F6DD0E8F3B9040A77F857FCFAC452A01A3E05C@homegain1.homegain.com>
It is generally not recommended that you kill processes with anything
stronger than HUP, which is (I believe) what kill sends by default.
Stronger signals will cause all backends to kill themselves because of
paranoia about data corruption.
If the process does not respond to that, then there is no convenient
way to kill it.
You can correlate processes to queries using the pg_stat_activity view.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 22, 2005, at 6:03 PM, Ken Reid wrote:
> Hi Thomas.
>
> I have been searching high and low and cannot find a way to kill an
> individual
> user process with Postgres.
>
> I have tried using a kill -9 to kill a specific process but that
> brings the
> entire postmaster down.
>
> This seems to be a very common problem with no answers.
>
> Would you happen to know how to do this?
>
> Thanks.
>
> - Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tfo@sitening.com, Ken@homegain.com
Subject: Re: Killing Processes
In-Reply-To: <399c5204777051febd1e3432d981b03b@sitening.com>
References: <C0F6DD0E8F3B9040A77F857FCFAC452A01A3E05C@homegain1.homegain.com> <399c5204777051febd1e3432d981b03b@sitening.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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