Re: shared memory blocks?

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: rocael(at)usa(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: shared memory blocks?
Date: 2000-11-09 16:45:40
Message-ID: 3A0AD4B4.249BF898@cs.auc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

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(at)usa(dot)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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> <rocael(at)usa(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Diego A. Puertas F. 2000-11-09 21:25:29 Re: psql won't start
Previous Message Gerhard Kroder 2000-11-09 15:21:03 Re: psql won't start

Browse pgsql-sql by date

  From Date Subject
Next Message Cristóvão B. B. Dalla Costa 2000-11-09 18:59:48 Re: [sql]Joins
Previous Message Josh Berkus 2000-11-09 16:40:41 Requests for Development