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 this situation seems to create a chicken-and-egg problem. How can I reduce shared_buffers or max_connections prior to running initdb? > > 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 of which I can touch during initdb. "creating template1 database in /Volumes/Data/pgsql90b/base/1 ... FATAL: could not create shared memory segment: Cannot allocate 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/or its max_connections parameter (currently 14). The PostgreSQL documentation contains more information about shared memory configuration." Cheers, M -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
