Received: from aua2.aua.auc.dk (aua2.aua.auc.dk [130.225.54.5]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA9Fjls55797 for ; Thu, 9 Nov 2000 10:45:48 -0500 (EST) (envelope-from poulc@cs.auc.dk) Received: from obel.auc.dk (cw.obel.auc.dk [192.168.64.3]) by aua.auc.dk (PMDF V5.2-32 #30369) with SMTP id <01JWCD7B4QWE8Y7P22@aua.auc.dk> for pgsql-sql@postgresql.org; Thu, 9 Nov 2000 16:45:06 met Received: (qmail 11004 invoked from network); Thu, 09 Nov 2000 15:41:33 +0000 Received: from plc.obel.auc.dk (HELO cs.auc.dk) (192.168.64.31) by cw.obel.auc.dk with SMTP; Thu, 09 Nov 2000 15:41:33 +0000 Date: Thu, 09 Nov 2000 16:45:40 +0000 From: "Poul L. Christiansen" Subject: Re: shared memory blocks? To: rocael@usa.net Cc: pgsql-sql@postgresql.org Message-id: <3A0AD4B4.249BF898@cs.auc.dk> MIME-version: 1.0 X-Mailer: Mozilla 4.71 [en] (WinNT; I) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en,pdf References: <20001109142611.20332.qmail@nw171.netaddress.usa.net> X-Archive-Number: 200011/72 X-Sequence-Number: 103 This line will set the maximum shared memory in Linux to 64MB: echo 67108864 > /proc/sys/kernel/shmmax You can see your default maximum shared memory with this command: cat /proc/sys/kernel/shmmax You should probably set this line in /etc/rd.d/init.d/postgresql or somewhere else, before PostgreSQL starts because the change will be set back to the default value when Linux restarts. Poul L. Christiansen rocael@usa.net wrote: > > Hi, > how can I configure my kernel to make it work with shared memory blocks of > 8Mb? > I'm using RedHat 6.2 > > Thank you for your help! > Rocael. > > 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 > > ____________________________________________________________________ > Get free email and a permanent address at http://www.netaddress.com/?N=1