From owner-freebsd-jail@FreeBSD.ORG Wed Oct 24 13:55:58 2007 Return-Path: Delivered-To: freebsd-jail@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4C11416A41B; Wed, 24 Oct 2007 13:55:58 +0000 (UTC) (envelope-from hoschi@etain.frida.mouhaha.de) Received: from etain.frida.mouhaha.de (etain.frida.mouhaha.de [85.236.48.54]) by mx1.freebsd.org (Postfix) with ESMTP id 124FB13C48E; Wed, 24 Oct 2007 13:55:57 +0000 (UTC) (envelope-from hoschi@etain.frida.mouhaha.de) Received: from localhost (etain.frida.mouhaha.de [85.236.48.54]) by etain.frida.mouhaha.de (Postfix) with ESMTP id 8353B4B9172; Wed, 24 Oct 2007 15:55:40 +0200 (CEST) X-Virus-Scanned: amavisd-new at mouhaha.de Received: from etain.frida.mouhaha.de ([85.236.48.54]) by localhost (etain.frida.mouhaha.de [85.236.48.54]) (amavisd-new, port 10024) with ESMTP id aN1XrI1wT3U6; Wed, 24 Oct 2007 15:55:37 +0200 (CEST) Received: by etain.frida.mouhaha.de (Postfix, from userid 1001) id AA0474B90E5; Wed, 24 Oct 2007 15:55:36 +0200 (CEST) Date: Wed, 24 Oct 2007 15:55:36 +0200 From: Oliver Peter To: freebsd-questions@FreeBSD.ORG Message-ID: <20071024135535.GC22904@nemesis.frida.mouhaha.de> References: <20071023180719.GA22904@nemesis.frida.mouhaha.de> <200710232006.l9NK67BO052981@lurza.secnetix.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="0vzXIDBeUiKkjNJl" Content-Disposition: inline In-Reply-To: <200710232006.l9NK67BO052981@lurza.secnetix.de> X-Operating-System: FreeBSD 6.2-RELEASE-p8 i386 User-Agent: Mutt/1.5.16 (2007-06-09) Cc: freebsd-jail@FreeBSD.ORG Subject: Re: multiple postgresql servers in multiple jails? X-BeenThere: freebsd-jail@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Discussion about FreeBSD jail\(8\)" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 24 Oct 2007 13:55:58 -0000 --0vzXIDBeUiKkjNJl Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Oct 23, 2007 at 10:06:08PM +0200, Oliver Fromme wrote: > Oliver Peter wrote: > > Does anybody have a running system with more than one jail hosting > > more than one postgres server? >=20 > Yes, you must configure them to use different port numbers, > because the SysV IPC IDs are derived from the port number. > If you try to run both servers with the default port, you'll > get a conflict. Configure different port numbers, and it > will work. Thanks for that hint. After changing the port numbers for each instance to a different one, it works - but only at first glance. After making some test creates and inserts to all servers at the same time I receive the 'out of memory' messages again... Different UIDs, different ports, same error. > By the way, the PostgreSQL developers do _not_ recommend to > run multiple servers on the same machine, because of bad > efficiency. It is much better (performance-wise) to run > all databases within the same server engine. PostgreSQL > has all the authentication and permission features you need > to separate multiple databases within a single server, so > there is really no need to use multiple jails. Of course I understand that. But I would like to setup a test server in a different jail beside my production jail/pgsql-server to be sure not to crash my production server. Performance does not matter (at this time in this specific case of course!). > I have these on a machine with a single PostgreSQL server, > as per recommendations of the developers: >=20 > options SHMMAXPGS=3D65536 > options SEMMAP=3D1024 > options SEMMNI=3D64 > options SEMMNS=3D1024 > options SEMUME=3D64 > options SEMMNU=3D128 Is this a good recommendation for a machine with only 1GB of RAM? --=20 Oliver PETER, eMail: hoschi@mouhaha.de, ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." --0vzXIDBeUiKkjNJl Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iEYEARECAAYFAkcfTtcACgkQ6LH/IUVtaI/aagCgnDHROiuJpkwyx9hBFytWeMdh ufwAnA0ntKl7vg3L9igJDywBb1u+GiD6 =Q0IV -----END PGP SIGNATURE----- --0vzXIDBeUiKkjNJl--