From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Need your help |
Date: | 2003-10-27 20:49:14 |
Message-ID: | Pine.LNX.4.44.0310272237450.19831-100000@emo.org.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-27 21:17:20 | Re: Partial/interrupted VACUUM FULL? |
Previous Message | Siddharth Rath (sirath) | 2003-10-27 20:12:03 | Need your help |