Received: from thelab.hub.org (nat0574.mpoweredpc.net [142.177.190.66]) by hub.org (8.9.1/8.9.1) with ESMTP id WAA17022 for ; Thu, 12 Nov 1998 22:49:32 -0500 (EST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id XAA06217; Thu, 12 Nov 1998 23:49:21 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Thu, 12 Nov 1998 23:49:21 -0400 (AST) From: The Hermit Hacker To: =?euc-kr?B?vNux4r/4?= cc: PostgreSQL-ADMIN Subject: Re: [SQL] Can't starting postmaster with -B 512 Option In-Reply-To: <005101be0eb1$f0034920$4157fbcb@m2000.www.m2000.co.kr> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: 8BIT 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