From: | Michael Fork <mfork(at)toledolink(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | SHMEM settings under FreeBSD |
Date: | 2001-03-19 05:24:43 |
Message-ID: | Pine.BSI.4.21.0103190016210.10409-100000@glass.toledolink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am trying to run postgres under 4.2-STABLE FreeBSD using a large amount
of shared memory, and am having problems finding the correct settings.
The box has 512MB or RAM, of which I would like for Postgres to use 400MB
for buffers and 32MB for sorting, which I determined would be:
-B 51200 (51200 pages * 8kb/page = 400*1024kb)
-S 32768 (since the value is in kb)
However, when starting I get the following error:
IpcMemoryCreate: shmget failed (Cannot allocate memory) key=5432001,
size=427022336, permission=600
I tried increasing the kern.ipc.shmmax to 427022336 and 457022336, but I
am stil unable to get postgres to start.
Any Ideas?
Thanks
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-19 06:40:01 | Re: SHMEM settings under FreeBSD |
Previous Message | mike | 2001-03-19 04:06:20 | Re: Graphics GUI for PostgreSQL |