On 05/11/2012 11:24, Yuri wrote:
When I am setting shared_buffers=6GB in postgresql.conf it fails to start:
DETAIL: Failed system call was shmget(key=5432001, size=6612361216, 03600).
even though kern.ipc.shmmax is set to ~7GB:
$ sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
Hi,
I'm running Postgresql 9.1 on FreeBSD 9.0 with the following settings:
# postgresql.conf
shared_buffers = 8GB # pgtune wizard 2012-04-04
# /boot/loader.conf
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.ipc.semumr=200
vm.pmap.shpgperproc=400
vm.pmap.pv_entry_max=50331648
