From owner-freebsd-stable@FreeBSD.ORG Tue Apr 26 16:59:14 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 211A216A4CE for ; Tue, 26 Apr 2005 16:59:14 +0000 (GMT) Received: from internet.potentialtech.com (h-66-167-251-6.phlapafg.covad.net [66.167.251.6]) by mx1.FreeBSD.org (Postfix) with ESMTP id D6D2B43D31 for ; Tue, 26 Apr 2005 16:59:13 +0000 (GMT) (envelope-from wmoran@potentialtech.com) Received: from localhost (24-53-250-148.pittpa.adelphia.net [24.53.250.148]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by internet.potentialtech.com (Postfix) with ESMTP id 243A169A21; Tue, 26 Apr 2005 12:59:13 -0400 (EDT) Date: Tue, 26 Apr 2005 12:59:12 -0400 From: Bill Moran To: "Marc G. Fournier" Message-Id: <20050426125912.01419be7.wmoran@potentialtech.com> In-Reply-To: <20050426135528.R32711@ganymede.hub.org> References: <426E5713.3010906@eurocom.od.ua> <20050426110923.3edf8a2e.wmoran@potentialtech.com> <20050426135528.R32711@ganymede.hub.org> Organization: Potential Technologies X-Mailer: Sylpheed version 1.0.4 (GTK+ 1.2.10; i386-portbld-freebsd5.3) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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: Tue, 26 Apr 2005 16:59:14 -0000 "Marc G. Fournier" wrote: > On Tue, 26 Apr 2005, Bill Moran wrote: > > > Alexander Rusinov wrote: > >> Hi, > >> > >> I need to run a number of PostgreSQL servers in different FreeBSD jails. > >> I managed to run a first instance of PostgreSQL server in a jail, but > >> after I launch a new server in another jail the first one starts to > >> return an error messages like the following: > >> > >> semctl(1507328, 4, SETVAL, 0) failed: Invalid argument > >> > >> The problem in general is: only one instance of PostgreSQL server > >> processes clients' connections, all of the others return semctl errors. > > > > I had this exact same problem. I never found a solution. The cause > > appears to be that, since shared memory is not segregated between jails, > > the newly launched Postgres instances corrupt the shared memory of > > previously running Postgres instances. > > I'm running 9 jails on a server right now, each with their own instance: > and never noticed any issues ... but, this is with 4.11, not 5.x, so maybe > something has changed? I was running 5.2 when I had the problems. So it's possible that this guess is correct. -- Bill Moran Potential Technologies http://www.potentialtech.com