You already have the answer. Of course the solution
has been described on the lists a few times. Open the
file /etc/rc in pico (don't forget to sudo) ( sudo
pico /etc/rc ). scroll down to the system tuning
section and change to look like this.
# System tuning
sysctl -w kern.maxvnodes=$(echo $(sysctl -n
hw.physmem) '33554432 / 512 * 1024 +p'|dc)
sysctl -w kern.sysv.shmmax=16777216
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536
These values work well. I don't know if they are
optimal for your system and setup.
Ted
--- "Reuven M. Lerner" <reuven@lerner.co.il> wrote:
> I just downloaded and compiled PostgreSQL 8.0 beta
> 3. The directory and
> files are all owned by the "postgres" user, and I
> compiled as that
> user. I configured with:
>
> ./configure --prefix=/sw --with-tcl --with-python
> --with-libs=/sw/lib/
> --with-includes=/sw/include/
>
> (/sw is the root of the "fink" hierarchy, analogous
> in some ways to the
> traditional /usr/local path.)
>
> The "make check" log included the following:
>
> creating template1 database in
> /Users/reuven/Downloads/postgresql-8.0.0beta3/src
> /test/regress/./tmp_check/data/base/1 ... FATAL:
> could not create
> shared memory
> segment: Cannot allocate memory
> DETAIL: Failed system call was shmget(key=2,
> size=1163264, 03600).
> HINT: This error usually means that PostgreSQL's
> request for a shared
> memory se
> gment exceeded available memory or swap space. To
> reduce the request
> size (curre
> ntly 1163264 bytes), reduce PostgreSQL's
> shared_buffers parameter
> (currently 50)
> and/or its max_connections parameter (currently
> 10).
> The PostgreSQL documentation contains more
> information about
> shared memo
> ry configuration.
> child process exited with exit code 1
> initdb: failed
> initdb: data directory
>
"/Users/reuven/Downloads/postgresql-8.0.0beta3/src/test/r
> egress/./tmp_check/data" not removed at user's
> request
>
> Reuven
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
