From owner-freebsd-questions@FreeBSD.ORG Sun Jan 6 20:20:57 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E2F2C16A417; Sun, 6 Jan 2008 20:20:57 +0000 (UTC) (envelope-from freebsd@hub.org) Received: from hub.org (hub.org [200.46.204.220]) by mx1.freebsd.org (Postfix) with ESMTP id B963213C469; Sun, 6 Jan 2008 20:20:57 +0000 (UTC) (envelope-from freebsd@hub.org) Received: from localhost (unknown [200.46.204.187]) by hub.org (Postfix) with ESMTP id D035011FDD31; Sun, 6 Jan 2008 16:20:56 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 62671-10; Sun, 6 Jan 2008 16:20:54 -0400 (AST) Received: from fserv.hub.org (blk-7-245-234.eastlink.ca [71.7.245.234]) by hub.org (Postfix) with ESMTP id C019311FDD2B; Sun, 6 Jan 2008 16:20:55 -0400 (AST) Received: from [192.168.1.2] (unknown [192.168.1.2]) by fserv.hub.org (Postfix) with ESMTP id 457798BC01; Sun, 6 Jan 2008 16:20:57 -0400 (AST) Date: Sun, 06 Jan 2008 16:20:50 -0400 From: "Marc G. Fournier" To: Oliver Peter , freebsd-questions@freebsd.org, freebsd-jail@freebsd.org Message-ID: <82C327FC3C9E75F1458EF3B0@ganymede.hub.org> In-Reply-To: <20071023180719.GA22904@nemesis.frida.mouhaha.de> References: <20071023180719.GA22904@nemesis.frida.mouhaha.de> X-Mailer: Mulberry/4.0.8 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: Subject: Re: multiple postgresql servers in multiple jails? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 06 Jan 2008 20:20:58 -0000 -----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 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-----