pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedshared memory blocks?
2+ messages / 2 participants
[nested] [flat]
* shared memory blocks?
@ 2000-11-09 07:26 rocael@usa.net
2000-11-09 16:45 ` Re: shared memory blocks? Poul L. Christiansen <poulc@cs.auc.dk>
0 siblings, 1 reply; 2+ messages in thread
From: rocael@usa.net @ 2000-11-09 07:26 UTC (permalink / raw)
To: rocael@usa.net; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: shared memory blocks?
2000-11-09 07:26 shared memory blocks? rocael@usa.net
@ 2000-11-09 16:45 ` Poul L. Christiansen <poulc@cs.auc.dk>
0 siblings, 0 replies; 2+ messages in thread
From: Poul L. Christiansen @ 2000-11-09 16:45 UTC (permalink / raw)
To: rocael@usa.net; +Cc: 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@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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-09 16:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-09 07:26 shared memory blocks? rocael@usa.net
2000-11-09 16:45 ` Poul L. Christiansen <poulc@cs.auc.dk>
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