pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can't starting postmaster with -B 512 Option
3+ messages / 3 participants
[nested] [flat]

* Can't starting postmaster with -B 512 Option
@ 1998-11-13 03:01 ¼Û±â¿ø <schiva@m2000.co.kr>
  1998-11-13 03:49 ` Re: [SQL] Can't starting postmaster with -B 512 Option The Hermit Hacker <scrappy@hub.org>
  0 siblings, 1 reply; 3+ messages in thread

From: ¼Û±â¿ø @ 1998-11-13 03:01 UTC (permalink / raw)
  To: pgsql-sql; PostgreSQL-other <pgsql-novice@postgresql.org>; PostgreSQL-hacker <pgsql-hackers@postgresql.org>; PostgreSQL-General <pgsql-general@postgresql.org>; PostgreSQL-ADMIN <pgsql-admin@postgresql.org>

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.....






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] Can't starting postmaster with -B 512 Option
  1998-11-13 03:01 Can't starting postmaster with -B 512 Option ¼Û±â¿ø <schiva@m2000.co.kr>
@ 1998-11-13 03:49 ` The Hermit Hacker <scrappy@hub.org>
  0 siblings, 0 replies; 3+ messages in thread

From: The Hermit Hacker @ 1998-11-13 03:49 UTC (permalink / raw)
  To: ¼Û±â¿ø <schiva@m2000.co.kr>; +Cc: PostgreSQL-ADMIN <pgsql-admin@postgreSQL.org>

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 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can't starting postmaster with -B 512 Option
@ 1998-11-13 14:49 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 1998-11-13 14:49 UTC (permalink / raw)
  To: schiva@m2000.co.kr; +Cc: pgsql-sql@hub.org

"=?euc-kr?B?vNux4r/4?=" <schiva@m2000.co.kr> writes:
> System Spec
>     SUN OS 2.6
>     PostgreSQL 6.3 Version
>
> sol% postmaster -B 512 -S -D /usr/local/pgsql/data
> FATAL 1:  ShmemCreate: cannot create region

> I don't know why error occured....

Probably your system has a small limit on the amount of memory that can
be reserved as shared memory.  This is a tunable kernel parameter on
most of the systems I know, but I don't know the exact procedure for
changing it on SunOS --- see your sysadmin, or start reading the manuals
if you are the sysadmin...

BTW, you should consider upgrading to Postgres 6.4.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1998-11-13 14:49 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-13 03:01 Can't starting postmaster with -B 512 Option ¼Û±â¿ø <schiva@m2000.co.kr>
1998-11-13 03:49 ` The Hermit Hacker <scrappy@hub.org>
1998-11-13 14:49 Re: Can't starting postmaster with -B 512 Option Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox