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