Re: Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3 - Mailing list pgsql-bugs

From Theodore Petrosky
Subject Re: Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3
Date
Msg-id 20041013114905.38699.qmail@web41012.mail.yahoo.com
Whole thread Raw
In response to Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3  ("Reuven M. Lerner" <reuven@lerner.co.il>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1285: Violacion de segmento
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #1285: Violacion de segmento