SHMEM settings under FreeBSD

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

Responses

Browse pgsql-admin by date

  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