multiple postgresql servers in multiple jails?

[Marc G. Fournier]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Talk about 'old email', but better then 'use different ports', which means you 
have to modify your clients for this ... after you install postgresql within 
the jail, vipw the password file and change the uid of the pgsql user (and 
chown the appropriate files) ... then you can run all instances on port 5432, 
which clients will expect, but without overrunning shared memory ...


- --On Tuesday, October 23, 2007 20:07:19 +0200 Oliver Peter <hoschi at mouhaha.de> 
wrote:

> 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."



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHgTgi4QvfyHIvDvMRArJ8AJ983aj4+QqbEbs/cFM6UIrby1DUJwCgwZfz
rg+dUi5ExXey99rpL/NLb/I=
=Z3xL
-----END PGP SIGNATURE-----