64 bit PG on OSX, FATAL: could not create shared memory segment

From: Kasper Frederiksen <kf(at)basepointmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 64 bit PG on OSX, FATAL: could not create shared memory segment
Date: 2007-08-23 14:04:34
Message-ID: 75A959C4-F8D7-4CFA-95C4-80D87CDCD154@basepointmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A while ago Kevin Murphy reported that PG built for 64 bit
archetecture cant start on a OSX:
http://archives.postgresql.org/pgsql-general/2007-04/msg00788.php

The problem was eventually traced to a compatability problem with OSX:
http://lists.apple.com/archives/darwin-kernel/2007/Apr/msg00021.html

I just tried with the new PG 8.2.4 and i get the exact same fatal error.

Does any one know of a patch that will fix this problem?
Or maby I need to build the binarys with different compiler flags?

---
I am running on a Intel Xeon OSX system

I configured PG with
./configure --prefix=pgsql64 --without-readline CFLAGS='-arch x86_64'

and the error is:
> /usr/local/pgsql64/bin/initdb -D /usr/local/pgsql64/data
The files belonging to this database system will be owned by user
"kasperf".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql64/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers/max_fsm_pages ... 400kB/20000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql64/data/base/1 ...
FATAL: could not create shared memory segment: Cann
ot allocate memory
DETAIL: Failed system call was shmget(key=1, size=1810432, 03600).
HINT: This error usually means that PostgreSQL's request for a
shared memory segment exceeded available memory or swa
p space. To reduce the request size (currently 1810432 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 memory configuration.
child process exited with exit code 1
initdb: removing contents of data directory "/usr/local/pgsql64/data"

Thanks,
Kasper Frederiksen

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-08-23 14:06:27 Re: Problem with UPDATE and UNIQUE
Previous Message Richard Huxton 2007-08-23 14:02:23 Re: Local authentication/security