By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,277 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,277 IT Pros & Developers. It's quick & easy.

Shared memory segment error

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
+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 ma*******@postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.