Re: MacOS X Shared Buffers (SHMMAX)?

From: Gregory Seidman <gss+pg(at)cs(dot)brown(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
Date: 2002-05-22 17:02:51
Message-ID: 20020522130251.B7586@jamaica.cs.brown.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-22 17:20:32 Re: MacOS X Shared Buffers (SHMMAX)?
Previous Message Andrew Sullivan 2002-05-22 16:12:07 Great Bridge benchmarks?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-05-22 17:20:32 Re: MacOS X Shared Buffers (SHMMAX)?
Previous Message Wm. G. Urquhart 2002-05-22 16:13:11 Re: Turning column into row