From owner-freebsd-stable@FreeBSD.ORG Mon May 2 15:34:11 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 C416F16A4CF for ; Mon, 2 May 2005 15:34:11 +0000 (GMT) Received: from bgo1smout1.broadpark.no (bgo1smout1.broadpark.no [217.13.4.94]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3422843D2F for ; Mon, 2 May 2005 15:34:11 +0000 (GMT) (envelope-from des@des.no) Received: from bgo1sminn1.broadpark.no ([217.13.4.93]) by bgo1smout1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0IFV007PICBBXR60@bgo1smout1.broadpark.no> for freebsd-stable@freebsd.org; Mon, 02 May 2005 17:28:23 +0200 (CEST) Received: from dsa.des.no ([80.203.228.37]) by bgo1sminn1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0IFV00KLBCME2IB0@bgo1sminn1.broadpark.no> for freebsd-stable@freebsd.org; Mon, 02 May 2005 17:35:03 +0200 (CEST) Received: by dsa.des.no (Pony Express, from userid 666) id 168F145131; Mon, 02 May 2005 17:34:09 +0200 (CEST) Received: from xps.des.no (xps.des.no [10.0.0.12]) by dsa.des.no (Pony Express) with ESMTP id 2AC1A9D1C7; Mon, 02 May 2005 17:34:05 +0200 (CEST) Received: by xps.des.no (Postfix, from userid 1001) id 1C2A233C39; Mon, 02 May 2005 17:34:05 +0200 (CEST) Date: Mon, 02 May 2005 17:34:05 +0200 From: des@des.no (=?iso-8859-1?q?Dag-Erling_Sm=F8rgrav?=) In-reply-to: <426F5A6E.4050208@eurocom.od.ua> To: Alexander Rusinov Message-id: <86acndmyky.fsf@xps.des.no> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on dsa.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> User-Agent: Gnus/5.110002 (No Gnus v0.2) Emacs/21.3 (berkeley-unix) X-Spam-Status: No, score=-2.8 required=5.0 tests=ALL_TRUSTED,AWL autolearn=disabled version=3.0.2 X-Spam-Level: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 02 May 2005 15:34:11 -0000 An unknown poster wrote: > AFAIR PostgreSQL generates the shared memory identifier based on > the port it is runing on. It is possible to run two instances of > PostgreSQL on different ports, so it should work if they are in > seperate jails. Correct. Alexander Rusinov writes: > I guess this is a workaround but not a solution though. 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 --=20 Dag-Erling Sm=F8rgrav - des@des.no