Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 3D38D4758A7 for ; Mon, 20 May 2002 23:06:44 -0400 (EDT) Received: from calypso.fmpro.com (unknown [209.242.196.81]) by postgresql.org (Postfix) with ESMTP id B066347587E for ; Mon, 20 May 2002 23:06:42 -0400 (EDT) Received: from [12.248.68.191] (12-248-68-191.client.attbi.com [12.248.68.191]) by calypso.fmpro.com (8.12.1/8.12.1) with ESMTP id g4KKqj2F022373; Mon, 20 May 2002 15:52:45 -0500 User-Agent: Microsoft-Entourage/10.0.0.1309 Date: Mon, 20 May 2002 20:59:32 -0500 Subject: Re: MacOS X Shared Buffers (SHMMAX)? From: Steve Lane To: "Command Prompt, Inc." , Cc: Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200205/710 X-Sequence-Number: 24690 On 5/20/02 9:25 PM, "Command Prompt, Inc." wrote: > Good day, > > Does anyone have any experience in increasing the amount of shared memory > buffers available to Mac OS X/Darwin? When starting with more than 128 > backend connections on a test G3 I encounter: > > ------------------------------------------------------------------------------ > ----- > IpcMemoryCreate: shmget(key=5432001, size=33357824, 03600) failed: Invalid > argument > > This error usually means that PostgreSQL's request for a shared memory > segment exceeded your kernel's SHMMAX parameter. You can either > reduce the request size or reconfigure the kernel with larger SHMMAX. > ------------------------------------------------------------------------------ > ----- > > However, I can find no helpful information looking around for how Darwin > handles this configuration. Hopefully it does not require a recompile of > the Kernel. ;) Actually --- :-> I'm no expert on this topic, but Darwin is BSD and I do recall a post on this very topic, to the effect that the poster believed some flavors of BSD, possibly MOSX included, do require rebuilding the kernel to change this value. As a MOSX user I'd certainly love to be found wrong. -- sgl ======================================================= Steve Lane Vice President Chris Moyer Consulting, Inc. 833 West Chicago Ave Suite 203 Voice: (312) 433-2421 Email: slane@fmpro.com Fax: (312) 850-3930 Web: http://www.fmpro.com =======================================================