From: Poul L. Christiansen <poulc@cs.auc.dk>
To: rocael@usa.net
Cc: pgsql-sql@postgresql.org
Subject: Re: shared memory blocks?
Date: Thu, 09 Nov 2000 16:45:40 +0000
Message-ID: <3A0AD4B4.249BF898@cs.auc.dk> (raw)
References: <20001109142611.20332.qmail@nw171.netaddress.usa.net>
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 <tgl@sss.pgh.pa.us> wrote:
> <rocael@usa.net> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: poulc@cs.auc.dk, rocael@usa.net
Subject: Re: shared memory blocks?
In-Reply-To: <3A0AD4B4.249BF898@cs.auc.dk>
References: <20001109142611.20332.qmail@nw171.netaddress.usa.net> <3A0AD4B4.249BF898@cs.auc.dk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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