Re: [BUGS] Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3

#1

"Reuven M. Lerner" <reuven (AT) lerner (DOT) co.il> writes:

Quote:

/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).

OS X has an unreasonably small limit on shared memory size; if you don't
raise it (IIRC you can do this in /etc/rc) then you don't get to have
more than one postmaster at a time.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#2

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 (AT) lerner (DOT) co.il> wrote:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#3

Tom Lane wrote:

Quote:

OS X has an unreasonably small limit on shared memory size; if you don't

raise it (IIRC you can do this in /etc/rc) then you don't get to have
more than one postmaster at a time.

OK, I see what you're talking about from looking in /etc/rc. You might

want to put something about this in the installation notes (if it's not
already there), and/or put something in "configure" itself to notify
users of this problem.

Thanks for the response!

Reuven

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3 - 10-12-2004 , 02:53 PM

Re: [BUGS] Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3 - 10-13-2004 , 06:50 AM

Re: [BUGS] Fatal "make check" bug with 8.0 beta 3 under Mac OS 10.3 - 10-14-2004 , 10:37 AM