From: | Alexander Cohen <alex(at)toomuchspace(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Shared memory segment error |
Date: | 2004-05-11 22:34:38 |
Message-ID: | 633CF457-A39B-11D8-96CA-000A95B947DC@toomuchspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas LeBlanc | 2004-05-11 22:36:16 | Updating a ADO RecordSet with INNER JOIN... |
Previous Message | Glenn Sullivan | 2004-05-11 22:10:51 | LISTEN/NOTIFY with JDBC |