Re: Need your help - Mailing list pgsql-admin

From Siddharth Rath (sirath)
Subject Re: Need your help
Date
Msg-id 00a201c39cd4$e441c060$f31ca143@amer.cisco.com
Whole thread Raw
In response to Re: Need your help  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: device full ---> postgres will not start
Next
From: "scott.marlowe"
Date:
Subject: Re: device full ---> postgres will not start