Seem that you hit the maximum limit of Linux kernel
(32 Mbyte shared memory). See the file
/usr/src/linux/include/asm-i386/shmparam.h
then edit the constant "SHMMAX" and rebuild your
kernel.
Hui :)
-----------
I have the new Postgres 6.4 installed. My system has 256 Meg of RAM with
512 Meg of swap space (PII/400 MHz; RH Linux 5.1). I am trying to
maximize the number of shared memory buffers for the postmaster. It
seems that if I get over 28 megs (-B3500), that the postmaster won't
run:
nohup postmaster -i -B4000 > regress.log &
[1] 737
[postgres@bigred ~]$ IpcMemoryCreate: shmget failed (Invalid argument)
key=5432001, size=33719840, permission=600
FATAL 1: ShmemCreate: cannot create region
I think that with 256 Meg of RAM that I should be able to extend that
shared buffer size even further. Is this a limitation of Postgres or is
this just that my system only has 28 meg to spare? (Or am I doing
something wrong).
Thanks.
-Tony
------------------------------------------------------------
Vuthichai Ampornaramveth <vuthi@venus.dtinet.or.jp>
Tokyo Institute of Technology <vuthi@ctrl.titech.ac.jp>
http://thaigate.nacsis.ac.jp/
