Re: [SQL] Can't starting postmaster with -B 512 Option

On Fri, 13 Nov 1998, [euc-kr] �۱��� wrote:

> System Spec
>     SUN OS 2.6
>     PostgreSQL 6.3 Version
>
> [Error Message]
> sol% postmaster -B 512 -S -D /usr/local/pgsql/data
> IpcMemoryCreate: memKey=5432001 , size=4501144 ,
> permission=384IpcMemoryCreate: shmget(..., create, ...) failed: Invalid
> argument
> This type of error is usually caused by improper
> shared memory or System V IPC semaphore configuration.
> See the FAQ for more detailed information
> FATAL 1:  ShmemCreate: cannot create region
>
> I don't know why error occured....
> Please.. Help me.....

First off...pick a list, don't send to them all...have narrowed it down to
the only one that was appropriate...

Second of all...Under Solaris 2.6, you have to raise the shared memory
segments available via the /etc/systems file.  I don' have the appropriate
document sittin gin front of me, or else I'd try and give you a more
detailed answer, but, for example, one of our Solaris machines at the
office as the following in its /etc/system file:

set shmsys:shminfo_shmmax=16777216
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=51

Each of the values tend to "inter-relate"...so you'll want to read up on
the appropriate docs for this, available through Sun...

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org