Received: from web10004.mail.yahoo.com (web10004.mail.yahoo.com [216.136.130.40]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eADCIos69145 for ; Mon, 13 Nov 2000 07:18:50 -0500 (EST) (envelope-from michael_teter@yahoo.com) Message-ID: <20001113121743.87597.qmail@web10004.mail.yahoo.com> Received: from [207.239.163.250] by web10004.mail.yahoo.com; Mon, 13 Nov 2000 04:17:43 PST Date: Mon, 13 Nov 2000 04:17:43 -0800 (PST) From: Michael Teter Subject: Re: shared memory problem To: Tom Lane , rocael@usa.net Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200011/90 X-Sequence-Number: 121 I'm not sure if this is related, and unfortunately I don't have the specific error in front of me, but on occasion when I restart postgresql, using $ /etc/rc.d/init.d/postgresql restart I'll see the shutdown message, then I'll see a shared memory creation error, which I think looked similar to the one below. In the past I would just boot the box, and postgresql naturally would start up just fine. But last time it happened I waited a minute, then attempted the restart again (which obviously would just do a start, as postgresql wasn't running because of previous failure.) It started up fine that time. Perhaps there's some issue with the shared memory not being freed quickly enough by the kernel? michael --- Tom Lane wrote: > writes: > > /usr/local/pgsql/bin/postmaster -B 1000 -o "-S > 2000" -S -D > > /usr/local/pgsql/data > > > and it says: > > IpcMemoryCreate: shmget failed (Invalid argument) > key=5432001, > > size=8899584,permission=600 > > This type of erro is usually caused by an improper > shared memory or System V > > IPC semaphore configuration. Form more > information.... > > Most likely your kernel isn't set to allow shared > memory blocks as > large as 8M. > > regards, tom lane __________________________________________________ Do You Yahoo!? Yahoo! Calendar - Get organized for the holidays! http://calendar.yahoo.com/