[DOCS] Issue with SHMALL parameter

2012-09-18 Thread data tanger
Hi, I'm using postgresql 9.1 as my database server on a linux server that has 8 GB of RAM. After I changed the shared_buffers parameter to 2GB, I get the following error when I try to start postgres: FATAL: could not create shared memory segment: Cannot allocate memoryDETAIL: Failed system ca

Re: [DOCS] Issue with SHMALL parameter

2012-09-18 Thread Tom Lane
data tanger writes: > Here are the shmall and the shmax params of my server: > #cat /proc/sys/kernel/shmmax 68719476736 > #cat /proc/sys/kernel/shmall 4294967296 SHMALL is measured in pages not bytes on Linux. I wonder if that value is too large and is causing an internal integer overflo

Re: [DOCS] Issue with SHMALL parameter

2012-09-18 Thread data tanger
Thank you for your answer. I think the value of shmall I have is very common cause I've seen it many times in other servers.Do you think there maybe a link between the request size of postgres and the swap size? Here is the output of free -m free -m total used free sh