[ADMIN] Need your help

[Siddharth Rath (sirath)]

Title: Message

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