-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi, On Mon, 27 Oct 2003, Siddharth Rath (sirath) wrote: <snip> > at the end of 6th step I did receivethe following in my log file. > I cant reconfigure the kernel with larger SHMMAX. > Please let me know how can I reduce the request size (currently 1499136 > bytes), reduce > PostgreSQL's shared_buffers parameter (currently 64) and/or > its max_connections parameter (currently 32). You do not need to reconfigure Linux kernel for a larger SHMMAX. As root, simply echo the new value into /proc/sys/kernel/shmmax: #echo 83886080 > /proc/sys/kernel/shmmax In the example above, we set the value of SHMMAX to 80 Mb. The change takes effect immediately but after a reboot, the original value is restored. If you put that line in /etc/rc.local (or equivalent), your system will set the SHMMAX value to the value you'll write there. If, one day, you need to reconfigure the kernel; then edit /usr/src/linux/include/asm/shmparam.h and recompile Linux. (maybe after reading http://www.linuxdoc.org/HOWTO/Kernel-HOWTO.html :) ) Regards, - -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE/nYTMtl86P3SPfQ4RAlM1AKCvvtQoQIAgnoXzB8/bG9KyjNnABACdGJBz OlT+4F3/3ntkWb/kgDxuJ/c= =7VLf -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
