From owner-freebsd-questions@FreeBSD.ORG Wed Mar 21 21:38:31 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id F255E16A518 for ; Wed, 21 Mar 2007 21:38:31 +0000 (UTC) (envelope-from fbsd-questions@mawer.org) Received: from customer-domains.icp-qv1-irony11.iinet.net.au (customer-domains.icp-qv1-irony11.iinet.net.au [203.59.1.151]) by mx1.freebsd.org (Postfix) with ESMTP id 644DF13C4C5 for ; Wed, 21 Mar 2007 21:38:30 +0000 (UTC) (envelope-from fbsd-questions@mawer.org) Received: from 203-206-173-235.perm.iinet.net.au (HELO [10.24.1.1]) ([203.206.173.235]) by iinet-mail.icp-qv1-irony11.iinet.net.au with ESMTP; 22 Mar 2007 06:28:27 +0900 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgAAAAFAAUbLzq3r/2dsb2JhbAAN X-IronPort-AV: i="4.14,310,1170601200"; d="scan'208"; a="24015604:sNHT7601886" Message-ID: <4601A381.1030301@mawer.org> Date: Thu, 22 Mar 2007 08:28:33 +1100 From: Antony Mawer User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Greg Barniskis References: <42991.167.246.36.14.1174490156.squirrel@webmail.dfwlp.org> <4601501C.3060605@gmail.com> <10072.167.246.36.14.1174492472.squirrel@webmail.dfwlp.org> <20070321121031.d95cadf6.wmoran@potentialtech.com> <46015BFD.4060806@scls.lib.wi.us> <20070321122852.8eaa2663.wmoran@potentialtech.com> <4601626B.1070702@scls.lib.wi.us> In-Reply-To: <4601626B.1070702@scls.lib.wi.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Jonathan Horne , Bill Moran , freebsd-questions@freebsd.org Subject: Re: started playing with jails X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 Mar 2007 21:38:32 -0000 On 22/03/2007 3:50 AM, Greg Barniskis wrote: > Bill Moran wrote: >> My experiments with Postgres in jail predate the existence of that >> setting. >> When I was working with it, you had to frob a sysctl via /etc/sysctl.conf >> >> But even then, I couldn't seem to get it to work -- the Postgres in the >> jail would corrupt the shared memory of the postgres outside the jail. >> It was ugly. Imagine big, wet tears rolling down my cheeks. >> >> I haven't had the need to try it in a while, so it might work OK now, I >> just don't know. >> > > Ah, now that you mention it I do recall discussions of multiple > instances peeing in each others pools so to speak. I also thought there > was discussion of how to fix it, but have no idea where that went if > anywhere... > > A single instance inside a jail does work quite happily if the knob > above is set. From memory, I think the discussion went something like "Postgres uses the TCP port number it binds to as its SYSV IPC ID... so if you want to run multiple instances in jails/etc without conflict, run them on different port numbers (and consequentially they will get separate SYSV IPC IDs)". --Antony