From: Command Prompt, Inc. <pgsql-general@commandprompt.com>
To: Gregory Seidman <gss+pg@cs.brown.edu>
Cc: pgsql-general@postgresql.org
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
Date: Wed, 22 May 2002 11:57:43 -0700 (PDT)
Message-ID: <Pine.LNX.4.30.0205221152310.18514-100000@commandprompt.com> (raw)
In-Reply-To: <20020522130251.B7586@jamaica.cs.brown.edu>
On Wed, 22 May 2002, Gregory Seidman wrote:
>Command Prompt, Inc. sez:
>[...]
>}Okay, so it appears to be when it's checking sockets for data in
>}src/backend/postmaster/pgstat.c, line 1579...I just tried re-building the
>}kernel with a higher value for kern.ipc.maxsockets but that didn't have
>}any effect, still get that error.
>}
>}Anyone have any ideas on what specifically would cause this part of pgstat
>}to fail?
>Recompiling the kernel was necessary to change the shared memory limit, but
>kern.ipc.maxsockets can be changed on the fly with sysctl.
Hm. I tried that, with "sysctl -w kern.ipcmaxsockets=2048", and got:
sysctl: oid 'kern.ipc.maxsockets' is read only
>It might be getting changed in one of the scripts (perhaps SystemTuning) in
>/System/Library/StartupItems (there are also sometimes scripts in
>/Library/StartupItems; both directories are used in the startup process).
>When your system is up and running, try sysctl kern.ipc.maxsockets and see
>if the value is what you expected. If not, dig around in the StartupItems
>directories and see if something is changing it.
After recompile it is actually the value I expected. It appears that the
problem is something less clear. :/
Jw.
--
jlx@commandprompt.com
by way of pgsql-general@commandprompt.com
http://www.postgresql.info/http://www.commandprompt.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: pgsql-general@commandprompt.com, gss+pg@cs.brown.edu, pgsql-general@postgresql.org
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
In-Reply-To: <Pine.LNX.4.30.0205221152310.18514-100000@commandprompt.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