Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 02 May 2005 17:34:05 +0200
From:      des@des.no (=?iso-8859-1?q?Dag-Erling_Sm=F8rgrav?=)
To:        Alexander Rusinov <boot@eurocom.od.ua>
Cc:        freebsd-stable@freebsd.org
Subject:   Re: PostgreSQL in FreeBSD jails
Message-ID:  <86acndmyky.fsf@xps.des.no>
In-Reply-To: <426F5A6E.4050208@eurocom.od.ua>
References:  <426E5713.3010906@eurocom.od.ua> <747dc8f30504260812ee3c47e@mail.gmail.com> <426E5EA5.8000703@eurocom.od.ua> <426F3AFA.9020900@konvergencia.hu> <426F5A6E.4050208@eurocom.od.ua>

next in thread | previous in thread | raw e-mail | index | archive | help
An unknown poster wrote:
> 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.

Correct.

Alexander Rusinov <boot@eurocom.od.ua> writes:
> I guess this is a workaround but not a solution though.

There are two possible solutions:

 - hack the SysV IPC code to use separate namespaces for each jail

 - make PostgreSQL use POSIX shared memory instead of SysV shared
   memory

I suspect that the latter is significantly easier, and would probably
improve performance as well.

DES
--=20
Dag-Erling Sm=F8rgrav - des@des.no



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?86acndmyky.fsf>