Re: shared memory on OS X - 7.4beta4

On 26/10/03 1:01 am, "John DeSoi" <jd(at)icx(dot)net> wrote:

>
> On Friday, October 24, 2003, at 10:19 AM, Adam Witney wrote:
>
>> I don't know what this error is particularly, but just to say that
>> 7.4beta5
>> compiles and starts up fine on my OSX 10.2.8 machine
>
> OK, I compiled beta 5 and put my rest SHMMAX back to the default
> settings as provided by OS X. Still the same error:
>
> FATAL: could not create shared memory segment: Invalid argument
> DETAIL: Failed system call was shmget(key=5432001, size=10444800,
> 03600).
> HINT: 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 10444800 bytes), reduce
> PostgreSQL's shared_buffers parameter (currently 1000) and/or its
> max_connections parameter (currently 100).
> 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 documentation contains more information about shared
> memory configuration.
>
> Here is how I configured it:
>
> ./configure --prefix=/Unix/postgresql --enable-locale
> --without-readline --with-includes=/sw/include --with-libraries=/sw/lib
> --with-openssl=/sw/lib
>
>
> Next I upgraded to 10.2.8. Same issue.
>
> So you have not modified your memory settings in
> /System/Library/StartupItems/SystemTuning/SystemTuning and you don't
> get this error?

Ah, yes I did change these... Mine are set to

sysctl -w kern.sysv.shmmax=4194304
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=1024

> I'm using a PowerBook G4 with 512M of memory.

Same as me

Do you have many other applications running? Or an old version of
PostgreSQL... I found when running the regression tests I had to shut down
my 7.3.2 installation

Cheers

adam

adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.