pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCan'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>
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:49 The Hermit Hacker <scrappy@hub.org>
parent: ¼Û±â¿ø <schiva@m2000.co.kr>
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