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
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 |
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 |