Shared memory segment error

[Alexander Cohen]

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
[phone]
[phone]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Joshua D. Drake]

Hello,

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.
[phone] - jd@commandpromp t.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org