From: Steve Lane <slane@fmpro.com>
To: Command Prompt, Inc. <pgsql-general@commandprompt.com>
To: pgsql-general@postgresql.org
Cc: jlx@commandprompt.com
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
Date: Mon, 20 May 2002 20:59:32 -0500
Message-ID: <B90F1435.D909%slane@fmpro.com> (raw)
In-Reply-To: <Pine.LNX.4.30.0205201919440.902-100000@commandprompt.com>
On 5/20/02 9:25 PM, "Command Prompt, Inc." <pgsql-general@commandprompt.com>
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
=======================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: slane@fmpro.com, pgsql-general@commandprompt.com, pgsql-general@postgresql.org, jlx@commandprompt.com
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
In-Reply-To: <B90F1435.D909%slane@fmpro.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox