multiple postgresql servers in multiple jails?

[Oliver Peter]

Does anybody have a running system with more than one jail hosting
more than one postgres server?

I can only have one pgsql database on one host at all.  I already
tried to increase the shared memory off my machine with additional
kernel [1] and sysctl parameters [2] and I also tried to change
the numeric UID directly in the jails into a seperate one.  Same
errors.

Of course I already have defined  jail_sysvipc_allow="YES"  in
rc.conf.  I have this issue on 6.2-RELEASE-p8 and 8.0-CURRENT with
postgresql-server-8.2.5_1.

------------------------------------------------------------------------
% psql
psql: FATAL:  semctl(458753, 15, SETVAL, 0) failed: Invalid argument
------------------------------------------------------------------------

Or some fun with perl/DBD
------------------------------------------------------------------------
Out of memory during request for 108 bytes, total sbrk() is 534585344 bytes!
Out of memory during request for 288 bytes, total sbrk() is 534585344 bytes!
Out of memory during request for 288 bytes, total sbrk() is 534585344 bytes!
------------------------------------------------------------------------

[1]
options         SYSVSHM
options         SYSVSEM
options         SYSVMSG
options         SHMMAXPGS=65536
options         SEMMNI=40
options         SEMMNS=240
options         SEMUME=40
options         SEMMNU=120

[2] http://www.freebsddiary.org/jail-multiple.php

-- 
Oliver PETER, eMail: hoschi at mouhaha.de, ICQ# 113969174
"Worker bees can leave.  Even drones can fly away.
                         The Queen is their slave."
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20071023/33219bfc/attachment.pgp