Date: Sun, 06 Jan 2008 16:20:50 -0400 From: "Marc G. Fournier" <freebsd@hub.org> To: Oliver Peter <hoschi@mouhaha.de>, freebsd-questions@freebsd.org, freebsd-jail@freebsd.org Subject: Re: multiple postgresql servers in multiple jails? Message-ID: <82C327FC3C9E75F1458EF3B0@ganymede.hub.org> In-Reply-To: <20071023180719.GA22904@nemesis.frida.mouhaha.de> References: <20071023180719.GA22904@nemesis.frida.mouhaha.de>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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@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@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@hub.org MSN . scrappy@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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?82C327FC3C9E75F1458EF3B0>