SHMEM settings under FreeBSD - Mailing list pgsql-admin

From Michael Fork
Subject SHMEM settings under FreeBSD
Date
Msg-id Pine.BSI.4.21.0103190016210.10409-100000@glass.toledolink.com
Whole thread Raw
Responses Re: SHMEM settings under FreeBSD  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-admin by date:

Previous
From: "mike"
Date:
Subject: Re: Graphics GUI for PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: SHMEM settings under FreeBSD