From owner-freebsd-stable@FreeBSD.ORG  Tue Apr 26 19:58:23 2005
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
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 EBC2816A4CE
	for <freebsd-stable@freebsd.org>;
	Tue, 26 Apr 2005 19:58:23 +0000 (GMT)
Received: from main.eurocom.od.ua (ns2.EuroCom.Od.UA [212.15.128.6])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 22EF943D1F
	for <freebsd-stable@freebsd.org>;
	Tue, 26 Apr 2005 19:58:23 +0000 (GMT)
	(envelope-from boot@eurocom.od.ua)
Received: from localhost (localhost [127.0.0.1])
	by main.eurocom.od.ua (Postfix) with ESMTP id 45BBC1C9DA7;
	Tue, 26 Apr 2005 22:58:20 +0300 (EEST)
Received: from main.eurocom.od.ua ([127.0.0.1])
 by localhost (main [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
 id 06266-09; Tue, 26 Apr 2005 22:58:19 +0300 (EEST)
Received: from [212.15.128.197] (boot.eurocom.od.ua [212.15.128.197])
	by main.eurocom.od.ua (Postfix) with ESMTP id CCCC61C9D82;
	Tue, 26 Apr 2005 22:58:18 +0300 (EEST)
Message-ID: <426E9D90.4030000@eurocom.od.ua>
Date: Tue, 26 Apr 2005 22:59:12 +0300
From: Alexander Rusinov <boot@eurocom.od.ua>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.2) Gecko/20041022
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "Marc G. Fournier" <scrappy@hub.org>
References: <426E5713.3010906@eurocom.od.ua>
	<20050426110923.3edf8a2e.wmoran@potentialtech.com>
	<20050426135528.R32711@ganymede.hub.org>
In-Reply-To: <20050426135528.R32711@ganymede.hub.org>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at eurocom.od.ua
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
	<freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 26 Apr 2005 19:58:24 -0000

Marc G. Fournier wrote:

> On Tue, 26 Apr 2005, Bill Moran wrote:
>
>> Alexander Rusinov <boot@eurocom.od.ua> 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?


Can you tell please what version of PostgreSQL are you running?