From: | Dana Hudes <dhudes(at)tcp-ip(dot)info> |
---|---|
To: | beyaNet Consultancy <beyanet(at)ntlworld(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: could not create shared memory segment: Invalid argument |
Date: | 2004-03-16 13:02:19 |
Message-ID: | Pine.LNX.4.58.0403160757480.11286@screamer.tcp-ip.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Theodore Petrosky | 2004-03-16 14:31:07 | Re: [SQL] could not create shared memory segment: Invalid argument |
Previous Message | Achilleus Mantzios | 2004-03-16 12:45:03 | Re: could not create shared memory segment: Invalid argument |
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Finner | 2004-03-16 13:30:23 | Re: flat file database to postgres |
Previous Message | Achilleus Mantzios | 2004-03-16 12:45:03 | Re: could not create shared memory segment: Invalid argument |