Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C7FC864FC0D
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 22 Sep 2008 13:03:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 16533-02-5 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 22 Sep 2008 13:03:52 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.digitalfreaks.org (arbitor.digitalfreaks.org
	[216.151.95.158])
	by postgresql.org (Postfix) with ESMTP id F0EAC650123
	for <pgsql-admin@postgresql.org>; Mon, 22 Sep 2008 13:00:30 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mail.digitalfreaks.org (Postfix) with ESMTP id 4014717915;
	Mon, 22 Sep 2008 12:00:28 -0400 (EDT)
Received: from mail.digitalfreaks.org ([127.0.0.1])
	by localhost (mail.digitalfreaks.org [127.0.0.1]) (amavisd-maia,
	port 10024)
	with ESMTP id 50627-14; Mon, 22 Sep 2008 12:00:24 -0400 (EDT)
Received: from [192.168.2.161] (pr40.pitbpa0.pub.collaborativefusion.com
	[206.210.89.202])
	(using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.digitalfreaks.org (Postfix) with ESMTPSA id F177018483;
	Mon, 22 Sep 2008 12:00:23 -0400 (EDT)
Subject: Re: SIGKILL and force disconnecting user sessions
From: "Brian A. Seklecki" <lavalamp@spiritual-machines.org>
To: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <20080922150634.GE10876@easy2.in-chemnitz.de>
References: 
 <1222091009.3153.84.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
	<20080922150634.GE10876@easy2.in-chemnitz.de>
Content-Type: text/plain
Date: Mon, 22 Sep 2008 12:00:23 -0400
Message-Id: 
 <1222099223.3153.122.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.22.3.1 (2.22.3.1-1.fc9) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200809/232
X-Sequence-Number: 30325

On Mon, 2008-09-22 at 17:06 +0200, Tino Schwarze wrote:
> 
> As far, as you do not really use SIGKILL (9), but SIGTERM (15),
> everything should be fine.

Yea my bad -- SIGTERM not SIGKILL.

Thanks for confirming.

A nice little SQL macro would be awesome: DISCONNECT or TERMINATE

But handling it via the POSIX layer is much more pragmatic.  

~BAS