PostgreSQL in FreeBSD jails

[Richard Coleman]

Dag-Erling Smørgrav wrote:
> 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

It might be easier to hack PostgreSQL so that the shared memory 
identifier depends not only on the port, but also on the IP address 
(which will of course be different for each jail).  Or better yet, to be 
able to specify the shared memory identifier to use directly in the 
config file.

Richard Coleman
rcoleman at criticalmagic.com