Thread: Need your help

Need your help

From
"Siddharth Rath (sirath)"
Date:
Hi,
I'm quite new to PostgresSQL and facing a trouble while trying to install and run as per the
guide line.
 
I did the following : Installing from su systran :
1) ./configure --enable-multibyte --with-perl --without-readline --prefix=/apps/systran/postgresql --bindir=/apps/systran/postgresql/bin --datadir=/apps/systran/postgresql/share && make && make install
(--without-readline  option is there as it was throwing an error that the same libs are missing and suggested to use this option)
2)make
3)make install
4)mkdir /apps/systran/postgresql/data
5)/apps/systran/postgresql/bin/initdb -D /apps/systran/postgresql/data
6)/apps/systran/postgresql/bin/postmaster -D  /apps/systran/postgresql/data >logfile 2>&1 &
 
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).
*************************************************************************************************************************
Error details :
 
 
IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Invalid argument
 
This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter.  You can either
reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduce the request size (currently 1499136 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).
 
If the request size is already small, it's possible that it is less than
your kernel's SHMMIN parameter, in which case raising the request size or
reconfiguring SHMMIN is called for.
 
The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.
***********************************************************************************************************************************
 
 
thanx in advance
 
Regards
Sidd

Re: Need your help

From
Devrim GUNDUZ
Date:
-----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-----


Re: Need your help

From
"Siddharth Rath (sirath)"
Date:
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