Re: MacOS X Shared Buffers (SHMMAX)? - Mailing list pgsql-general

From Gregory Seidman
Subject Re: MacOS X Shared Buffers (SHMMAX)?
Date
Msg-id 20020522130251.B7586@jamaica.cs.brown.edu
Whole thread Raw
In response to Re: MacOS X Shared Buffers (SHMMAX)?  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
Responses Re: MacOS X Shared Buffers (SHMMAX)?
List pgsql-general
Command Prompt, Inc. sez:
[...]
} [...actually, a minute later of looking at the source...]
}
} 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. 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.

} Best regards,
} Jw.
--Greg


pgsql-general by date:

Previous
From: "Command Prompt, Inc."
Date:
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
Next
From: Tom Lane
Date:
Subject: Re: MacOS X Shared Buffers (SHMMAX)?