From owner-freebsd-stable@FreeBSD.ORG  Wed Apr 27 09:25:06 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 0812016A4CE
	for <freebsd-stable@freebsd.org>;
	Wed, 27 Apr 2005 09:25:06 +0000 (GMT)
Received: from main.eurocom.od.ua (ns2.EuroCom.Od.UA [212.15.128.6])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 33CC743D48
	for <freebsd-stable@freebsd.org>;
	Wed, 27 Apr 2005 09:25:05 +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 57BED1C97FE;
	Wed, 27 Apr 2005 12:25:03 +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 00830-10; Wed, 27 Apr 2005 12:25:02 +0300 (EEST)
Received: from [212.15.128.37] (bm0.eurocom.od.ua [212.15.128.14])
	by main.eurocom.od.ua (Postfix) with ESMTP id 674F01C977E;
	Wed, 27 Apr 2005 12:25:02 +0300 (EEST)
Message-ID: <426F5A6E.4050208@eurocom.od.ua>
Date: Wed, 27 Apr 2005 12:25:02 +0300
From: Alexander Rusinov <boot@eurocom.od.ua>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.6) Gecko/20050404
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-stable@freebsd.org
References: <426E5713.3010906@eurocom.od.ua>
	<747dc8f30504260812ee3c47e@mail.gmail.com> <426E5EA5.8000703@eurocom.od.ua>
	<426F3AFA.9020900@konvergencia.hu>
In-Reply-To: <426F3AFA.9020900@konvergencia.hu>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at eurocom.od.ua
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: Wed, 27 Apr 2005 09:25:06 -0000


>>>
>>> Just add the following line to your /etc/rc.conf
>>>
>>> jail_sysvipc_allow="YES"
>>> and ipc configuration will be shared with the jails
>>>  
>>>
>> I have IPC enabled for jails already. So unfortunately this is not a 
>> solution.
>>
>> Is anybody here who do run several jailed PostgreSQL servers?
>>
> 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.

Actually, I'm using unix sockets for those servers so I never thought 
about changing the port number. But now I tried and ... that helped! 
Thank you!

I guess this is a workaround but not a solution though.