Which OS are you running? If you are running Linux (RH or SuSE) you can just increase the setting per the sysctl.conf
kernel.shmmax = 65536 (64 megs or whatever you wish).
Sincerely,
Joshua D. Drake
Alexander Cohen wrote:
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!
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
