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