From owner-freebsd-current@FreeBSD.ORG Wed Apr 30 17:51:16 2003 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 97B8C37B401 for ; Wed, 30 Apr 2003 17:51:16 -0700 (PDT) Received: from pa-plum1b-166.pit.adelphia.net (pa-plum1a-215.pit.adelphia.net [24.53.170.215]) by mx1.FreeBSD.org (Postfix) with ESMTP id AB48943F75 for ; Wed, 30 Apr 2003 17:51:15 -0700 (PDT) (envelope-from wmoran@potentialtech.com) Received: from potentialtech.com (working [172.16.0.95]) h410pB0n005417; Wed, 30 Apr 2003 20:51:11 -0400 (EDT) (envelope-from wmoran@potentialtech.com) Message-ID: <3EB06F7F.9000203@potentialtech.com> Date: Wed, 30 Apr 2003 20:51:11 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Unix@henoc.com References: <3EB054B1.6040406@potentialtech.com> <200304301939.30567.Roger.Savard@henoc.com> In-Reply-To: <200304301939.30567.Roger.Savard@henoc.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-current@freebsd.org Subject: Re: PostgreSQL7 port fails when I try to run initdb X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 May 2003 00:51:16 -0000 Based on the additional information you got in your capture, I added the following options to my kernel: options SHMMAXPGS=65536 options SEMMNI=40 options SEMMNS=240 options SEMUME=40 options SEMMNU=120 and rebuilt it. initdb then ran successfully, and Postgre was able to start from the rc script. I got this information from the PostgreSQL docs. It's supposed to be adding _more_ shared memory to allow Postgre to handle up to 180 clients. I wasn't sure if these options were still valid in 5, as I didn't see them in the docs anywhere (correct me if I'm wrong, but NOTES has replaced LINT, right?) Anyway, the kernel compiled without incident and booted without trouble. In 4, there was no need to change the defaults just to get Postgre running. I can only assume that the defaults have changed in 5. This should probably be documented somewhere (in the GENERIC file?) or the default values raised back to where they were in 4? Thanks Roger. Roger wrote: > Agreed Bill I have the same problem: > > %uname -a > FreeBSD freebee.henocoffice.com 5.0-CURRENT FreeBSD 5.0-CURRENT #0: Wed Apr 30 > 0 > 9:27:22 EDT 2003 > root@freebee.henocoffice.com:/usr/obj/.amd_mnt/haydn/host/u > sr/srcC/src/sys/GENERIC i386 > %initdb > The files belonging to this database system will be owned by user "pgsql". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > creating directory /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... ok > creating directory /usr/local/pgsql/data/pg_xlog... ok > creating directory /usr/local/pgsql/data/pg_clog... ok > creating template1 database in /usr/local/pgsql/data/base/1... > IpcSemaphoreCreat > e: semget(key=1, num=17, 03600) failed: No space left on device > > This error does *not* mean that you have run out of disk space. > > It occurs when either the system limit for the maximum number of > semaphore sets (SEMMNI), or the system wide maximum number of > semaphores (SEMMNS), would be exceeded. You need to raise the > respective kernel parameter. Alternatively, reduce PostgreSQL's > consumption of semaphores by reducing its max_connections parameter > (currently 1). > > The PostgreSQL Administrator's Guide contains more information about > configuring your system for PostgreSQL. -- Bill Moran Potential Technologies http://www.potentialtech.com