Re: could not create shared memory segment: Invalid argument - Mailing list pgsql-sql

From Dana Hudes
Subject Re: could not create shared memory segment: Invalid argument
Date
Msg-id Pine.LNX.4.58.0403160757480.11286@screamer.tcp-ip.info
Whole thread Raw
In response to could not create shared memory segment: Invalid argument  (beyaNet Consultancy <beyanet@ntlworld.com>)
List pgsql-sql
Well, did you consider getting the value of SHMMAX?
Check with ulimit  (as the postgres user).

On Tue, 16 Mar 2004, beyaNet Consultancy wrote:

> Hi,
> I have just installed the latest version of OS X panther (10.3.3) and 
> am now getting the following error message:
> 
> postgres$ /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data
> 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.
> 
> Any ideas on how i can resolve this issue?
> 
> many thanks in advance
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 


pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: could not create shared memory segment: Invalid argument
Next
From: Frank Finner
Date:
Subject: Re: flat file database to postgres