From owner-freebsd-stable@FreeBSD.ORG Mon May 2 21:03:34 2005 Return-Path: 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 4511216A4CF for ; Mon, 2 May 2005 21:03:34 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by mx1.FreeBSD.org (Postfix) with ESMTP id D4BF643D7E for ; Mon, 2 May 2005 21:03:33 +0000 (GMT) (envelope-from scrappy@hub.org) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 15AD764DC36; Mon, 2 May 2005 18:03:33 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06726-05; Mon, 2 May 2005 21:03:29 +0000 (GMT) Received: from ganymede.hub.org (blk-222-80-207.eastlink.ca [24.222.80.207]) by hub.org (Postfix) with ESMTP id 99F4764DC35; Mon, 2 May 2005 18:03:32 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 8DCAC350FE; Mon, 2 May 2005 18:03:31 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 8CC3C340CF; Mon, 2 May 2005 18:03:31 -0300 (ADT) Date: Mon, 2 May 2005 18:03:31 -0300 (ADT) From: "Marc G. Fournier" To: Richard Coleman In-Reply-To: <4276910A.3040100@criticalmagic.com> Message-ID: <20050502180152.I53065@ganymede.hub.org> 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> <4276910A.3040100@criticalmagic.com> MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="0-703306083-1115067811=:53065" X-Virus-Scanned: by amavisd-new at hub.org cc: =?ISO-8859-1?Q?Dag-Erling_Sm=F8rgrav?= cc: freebsd-stable@freebsd.org cc: Alexander Rusinov 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 02 May 2005 21:03:34 -0000 This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. --0-703306083-1115067811=:53065 Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: QUOTED-PRINTABLE yOn Mon, 2 May 2005, Richard Coleman wrote: > Dag-Erling Sm=F8rgrav wrote: >> There are two possible solutions: >>=20 >> - hack the SysV IPC code to use separate namespaces for each jail >>=20 >> - make PostgreSQL use POSIX shared memory instead of SysV shared >> memory >>=20 >> I suspect that the latter is significantly easier, and would probably >> improve performance as well. >>=20 >> DES > > It might be easier to hack PostgreSQL so that the shared memory identifie= r=20 > depends not only on the port, but also on the IP address (which will of= =20 > course be different for each jail). Or better yet, to be able to specify= the=20 > shared memory identifier to use directly in the config file. You've all lost me here ... what exactly is the problem? PostgreSQL works= =20 under FreeBSD 4.x jails without any modifications, so how is PostgreSQL=20 itself currently broken? It seems to me that the problem is with FreeBSD= =20 5.x's jail side of things, if the same daemon runs fine under 4.x, but,=20 nto under 5.x ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 --0-703306083-1115067811=:53065--