Shared memory segment error - Mailing list pgsql-general

From Alexander Cohen
Subject Shared memory segment error
Date
Msg-id 633CF457-A39B-11D8-96CA-000A95B947DC@toomuchspace.com
Whole thread Raw
Responses Re: Shared memory segment error  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Hi, sometimes ill get this error:

FATAL:  could not create shared memory segment: Cannot allocate memory
DETAIL:  Failed system call was shmget(key=2, size=4153344, 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 4153344 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 400) and/or its max_connections
parameter (currently 20).
    The PostgreSQL documentation contains more information about shared
memory configuration.

I was what exactly this shared memory space is used for and what size
is good to set it to. I need to be able to start up many backends
(postgres) without using the postmaster.

thanks!

--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443


pgsql-general by date:

Previous
From: Glenn Sullivan
Date:
Subject: LISTEN/NOTIFY with JDBC
Next
From: "Thomas LeBlanc"
Date:
Subject: Updating a ADO RecordSet with INNER JOIN...