From owner-freebsd-questions@FreeBSD.ORG Tue Oct 23 20:07:42 2007 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 08FF416A417 for ; Tue, 23 Oct 2007 20:07:42 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8]) by mx1.freebsd.org (Postfix) with ESMTP id 7594713C48D for ; Tue, 23 Oct 2007 20:07:41 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (localhost [127.0.0.1]) by lurza.secnetix.de (8.14.1/8.14.1) with ESMTP id l9NK68Nw052982; Tue, 23 Oct 2007 22:06:13 +0200 (CEST) (envelope-from oliver.fromme@secnetix.de) Received: (from olli@localhost) by lurza.secnetix.de (8.14.1/8.14.1/Submit) id l9NK67BO052981; Tue, 23 Oct 2007 22:06:08 +0200 (CEST) (envelope-from olli) Date: Tue, 23 Oct 2007 22:06:08 +0200 (CEST) Message-Id: <200710232006.l9NK67BO052981@lurza.secnetix.de> From: Oliver Fromme To: freebsd-questions@FreeBSD.ORG, hoschi@mouhaha.de In-Reply-To: <20071023180719.GA22904@nemesis.frida.mouhaha.de> X-Newsgroups: list.freebsd-questions User-Agent: tin/1.8.3-20070201 ("Scotasay") (UNIX) (FreeBSD/6.2-STABLE-20070808 (i386)) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.1.2 (lurza.secnetix.de [127.0.0.1]); Tue, 23 Oct 2007 22:06:14 +0200 (CEST) Cc: Subject: Re: multiple postgresql servers in multiple jails? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd-questions@FreeBSD.ORG, hoschi@mouhaha.de List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Oct 2007 20:07:42 -0000 Oliver Peter wrote: > Does anybody have a running system with more than one jail hosting > more than one postgres server? 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. 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. > options SHMMAXPGS=65536 > options SEMMNI=40 > options SEMMNS=240 > options SEMUME=40 > options SEMMNU=120 I have these on a machine with a single PostgreSQL server, as per recommendations of the developers: options SHMMAXPGS=65536 options SEMMAP=1024 options SEMMNI=64 options SEMMNS=1024 options SEMUME=64 options SEMMNU=128 Best regards Oliver -- Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing b. M. Handelsregister: Registergericht Muenchen, HRA 74606, Geschäftsfuehrung: secnetix Verwaltungsgesellsch. mbH, Handelsregister: Registergericht Mün- chen, HRB 125758, Geschäftsführer: Maik Bachmann, Olaf Erb, Ralf Gebhart FreeBSD-Dienstleistungen, -Produkte und mehr: http://www.secnetix.de/bsd "C++ is the only current language making COBOL look good." -- Bertrand Meyer