Re: initdb fails to allocate shared memory

On Aug 25, 2010, at 11:31 AM, Joshua D. Drake wrote:

> On Wed, 2010-08-25 at 11:15 -0400, A.M. wrote:
>> I am using pgsql9.0b4 (but pgsql8.4 exhibits the same behavior) on MacOS 10.6.4 and initdb fails:
>> initdb: removing data directory "/Volumes/Data/pgsql90b"
>>
>> I would like to create the database space and then reduce the shared memory requirements in postgresql.conf, but
thissituation seems to create a chicken-and-egg problem. How can I reduce shared_buffers or max_connections prior to
runninginitdb? 
>
> If you don't have enough shared memory to initdb, you don't have enough
> to run postgresql. You need to increase your shared memory for MacOS
> per:
>
> http://www.postgresql.org/docs/8.4/static/kernel-resources.html
>
> And then initdb.

Then it seems that the error reporting could be improved to not mention "shared_buffers" and "max_connections" neither
ofwhich I can touch during initdb. 

"creating template1 database in /Volumes/Data/pgsql90b/base/1 ... FATAL:  could not create shared memory segment:
Cannotallocate memory 
DETAIL:  Failed system call was shmget(key=1, size=1703936, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap
space.To reduce the request size (currently 1703936 bytes), reduce PostgreSQL's shared_buffers parameter (currently 50)
and/orits max_connections parameter (currently 14). 
    The PostgreSQL documentation contains more information about shared memory configuration."

Cheers,
M