Re: Need your help
От | Devrim GUNDUZ |
---|---|
Тема | Re: Need your help |
Дата | |
Msg-id | Pine.LNX.4.44.0310272237450.19831-100000@emo.org.tr обсуждение исходный текст |
Ответ на | Need your help ("Siddharth Rath (sirath)" <sirath@cisco.com>) |
Ответы |
Re: Need your help
|
Список | pgsql-admin |
-----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 devrim@gunduz.org devrim.gunduz@linux.org.tr 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-----
В списке pgsql-admin по дате отправления: