Re: Need your help - Mailing list pgsql-admin

From Devrim GUNDUZ
Subject Re: Need your help
Date
Msg-id Pine.LNX.4.44.0310272237450.19831-100000@emo.org.tr
Whole thread Raw
In response to Need your help  ("Siddharth Rath (sirath)" <sirath@cisco.com>)
Responses Re: Need your help  ("Siddharth Rath (sirath)" <sirath@cisco.com>)
List 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 by date:

Previous
From: "Siddharth Rath (sirath)"
Date:
Subject: Need your help
Next
From: Tom Lane
Date:
Subject: Re: Partial/interrupted VACUUM FULL?