Hi Devrim,
Thanx for the help. Is there anyway to maximize the
SHMMAX for the following M/C details :
Release: 5.8
Kernel architecture: sun4u
Application architecture: sparc
Hardware provider: Sun_Microsystems
Domain:
Kernel version: SunOS 5.8 Generic 108528-17 September 2002
I tried cat /proc/sys/kernel/shmmax and it says cat: cannot open
/proc/sys/kernel/shmmax
As thers no sys directory in /proc/ .
Thanx and regards
Sidd
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Devrim GUNDUZ
Sent: Monday, October 27, 2003 12:49 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need your help
-----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-----
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend