Date: Mon, 20 Mar 2006 14:36:47 -0600 From: Miguel <mmiranda@123.com.sv> To: freebsd-questions@freebsd.org Subject: setting shmmax for postgres Message-ID: <441F125F.8030101@123.com.sv>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?441F125F.8030101>