setting shmmax for postgres
Miguel
mmiranda at 123.com.sv
Mon Mar 20 20:33:14 UTC 2006
Hi, how can i set the shmmax parameter in freebsd 6.1?
i tried this in /etc/sysctl.conf
kern.ipc.shmmax=1147483647
shiva2# sysctl -a kern.ipc.shmmax
kern.ipc.shmmax: 2147483647
but postgres always fails with this error
The PostgreSQL documentation contains more information about shared
memory configuration.
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001, size=1149067264, 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 1149067264 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 137626) and/or its max_connections
parameter (currently 200).
do i have to recompile the kernel ?
thanks
More information about the freebsd-questions
mailing list