This line will set the maximum shared memory in Linux to 64MB:
echo 67108864 > /proc/sys/kernel/shmmax
You can see your default maximum shared memory with this command:
cat /proc/sys/kernel/shmmax
You should probably set this line in /etc/rd.d/init.d/postgresql or
somewhere else, before PostgreSQL starts because the change will be set
back to the default value when Linux restarts.
Poul L. Christiansen
rocael@usa.net wrote:
>
> Hi,
> how can I configure my kernel to make it work with shared memory blocks of
> 8Mb?
> I'm using RedHat 6.2
>
> Thank you for your help!
> Rocael.
>
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> <rocael@usa.net> writes:
> > /usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D
> > /usr/local/pgsql/data
>
> > and it says:
> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> > size=8899584,permission=600
> > This type of erro is usually caused by an improper shared memory or System
> V
> > IPC semaphore configuration. Form more information....
>
> Most likely your kernel isn't set to allow shared memory blocks as
> large as 8M.
>
> regards, tom lane
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1