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
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? |
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 |