Re: Need your help

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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Devrim GUNDUZ
Sent: Monday, October 27, 2003 12:49 PM
To: pgsql-admin(at)postgresql(dot)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(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-----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend