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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
