Re: shared memory on OS X - 7.4beta4

On Sunday, October 26, 2003, at 05:51 PM, Alvaro Herrera wrote:

> Huh, this is strange. IIRC during the installation process, initdb is
> supposed to determine which values actually work; those are affected by
> the shmmax operating system mostly, and the idea is to enable the
> installation process to pick more reasonable values out-of-the-box for
> memory usage that will work on your system.
>
> How did you install Postgres, and what values did initdb pick for
> shared_buffers and max_connections?

Here were my steps to install and attempt to run it:

Install (clean install to a new directory)

./configure --prefix=/Unix/postgresql --enable-locale
--without-readline --with-includes=/sw/include --with-libraries=/sw/lib
--with-openssl=/sw/lib
make
make install

Initdb:

initdb -D /data/pgtest --no-locale

Startup:

pg_ctl start -D /data/pgtest -l /data/pgtest/logfile -o '-i -p 5432'

the postgresql.conf has
max_connections = 100
shared_buffers = 1000

And here are are the default settings for OS X 10.2.6:

sysctl -w kern.sysv.shmmax=4194304
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=1024