Issue with SHMALL parameter
От
data tanger
Тема
Issue with SHMALL parameter
Дата
Msg-id
DUB103-W29E612B268EC42662EB1C7A1940@phx.gbl
Список
Дерево обсуждения
Issue with SHMALL parameter data tanger <datatanger@hotmail.fr>
Re: Issue with SHMALL parameter Tom Lane <tgl@sss.pgh.pa.us>
Re: Issue with SHMALL parameter data tanger <datatanger@hotmail.fr>
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 memory
DETAIL: 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
В списке pgsql-docs по дате отправления
От: Jeff Janes
Дата:
