From owner-freebsd-questions@FreeBSD.ORG Wed Mar 21 21:56:51 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 B909716A47A for ; Wed, 21 Mar 2007 21:56:51 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id 86BCF13C484 for ; Wed, 21 Mar 2007 21:56:51 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from vanquish.pgh.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTP id A2657EBC62; Wed, 21 Mar 2007 17:56:50 -0400 (EDT) Date: Wed, 21 Mar 2007 17:56:49 -0400 From: Bill Moran To: Antony Mawer Message-Id: <20070321175649.a3f16155.wmoran@potentialtech.com> In-Reply-To: <4601A381.1030301@mawer.org> 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> <4601A381.1030301@mawer.org> X-Mailer: Sylpheed 2.3.1 (GTK+ 2.10.9; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: Jonathan Horne , Greg Barniskis , 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:56:51 -0000 In response to Antony Mawer : > 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)". That's how I remember it as well. I don't remember being able to get it working with a different port # either, but it's been a while -- back when 7.4 was the latest. -- Bill Moran http://www.potentialtech.com