Issue with SHMALL parameter

From: data tanger <datatanger(at)hotmail(dot)fr>
To: <pgsql-docs(at)postgresql(dot)org>
Subject: Issue with SHMALL parameter
Date: 2012-09-18 13:59:53
Message-ID: DUB103-W29E612B268EC42662EB1C7A1940@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


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 call was shmget(key=5432001, size=2221539328, 03600).
Here are the shmall and the shmax params of my server:
#cat /proc/sys/kernel/shmmax 68719476736
#cat /proc/sys/kernel/shmall 4294967296
So as you see, shmall is greater than the requested size by postgres. Anyone have and idea?
thank you

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2012-09-18 16:07:46 Re: Issue with SHMALL parameter
Previous Message Bill Martin 2012-09-18 07:28:25 Re: Planner selects different execution plans depending on limit