From owner-freebsd-stable@FreeBSD.ORG  Mon May  2 20:42:57 2005
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id AF97C16A4CF
	for <freebsd-stable@freebsd.org>;
	Mon,  2 May 2005 20:42:57 +0000 (GMT)
Received: from saturn.criticalmagic.com (saturn.criticalmagic.com
	[69.61.68.51])	by mx1.FreeBSD.org (Postfix) with ESMTP id 4C52643D7E
	for <freebsd-stable@freebsd.org>;
	Mon,  2 May 2005 20:42:57 +0000 (GMT)
	(envelope-from rcoleman@criticalmagic.com)
Received: from [10.40.30.162] (delta.ciphertrust.com [216.235.158.34])
	by saturn.criticalmagic.com (Postfix) with ESMTP id 3CA463BD53;
	Mon,  2 May 2005 16:42:54 -0400 (EDT)
Message-ID: <4276910A.3040100@criticalmagic.com>
Date: Mon, 02 May 2005 16:43:54 -0400
From: Richard Coleman <rcoleman@criticalmagic.com>
Organization: Critical Magic
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050502)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: =?ISO-8859-1?Q?Dag-Erling_Sm=F8rgrav?= <des@des.no>
References: <426E5713.3010906@eurocom.od.ua>
	<747dc8f30504260812ee3c47e@mail.gmail.com> <426E5EA5.8000703@eurocom.od.ua>
	<426F3AFA.9020900@konvergencia.hu> <426F5A6E.4050208@eurocom.od.ua>
	<86acndmyky.fsf@xps.des.no>
In-Reply-To: <86acndmyky.fsf@xps.des.no>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
cc: Alexander Rusinov <boot@eurocom.od.ua>
cc: freebsd-stable@freebsd.org
Subject: Re: PostgreSQL in FreeBSD jails
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Production branch of FreeBSD source code
	<freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 02 May 2005 20:42:57 -0000

Dag-Erling Smørgrav wrote:
> There are two possible solutions:
> 
>  - hack the SysV IPC code to use separate namespaces for each jail
> 
>  - make PostgreSQL use POSIX shared memory instead of SysV shared
>    memory
> 
> I suspect that the latter is significantly easier, and would probably
> improve performance as well.
> 
> DES

It might be easier to hack PostgreSQL so that the shared memory 
identifier depends not only on the port, but also on the IP address 
(which will of course be different for each jail).  Or better yet, to be 
able to specify the shared memory identifier to use directly in the 
config file.

Richard Coleman
rcoleman@criticalmagic.com