PostgreSQL in FreeBSD jails

[Dag-Erling Smørgrav]

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 at 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
-- 
Dag-Erling Smørgrav - des at des.no