Re: Need your help

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-----

In response to

Responses

Browse pgsql-admin by date

  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