Re: Can't start Pgsql 7.1 on FreeBSD 4.2

Kurt Seel wrote:

> Postmaster spits out this :
> IpcMemoryCreate: shmget(key=5432001, size=1236992, 03600) failed: Cannot
> allocate memory
> When I try to start it. I compiled and installed from the ports
> collection.
>
> I compiled these into my kernel :
> options SYSVSHM #SYSV-style shared memory
> options SYSVMSG #SYSV-style message queues
> options SYSVSEM #SYSV-style semaphores
>
> Any ideas?

This is covered in more depth in the Admin documentation, chapter 3.5. An
online version can be found at:

http://postgresql.readysetnet.com/devel-corner/docs/admin/kernel-resources.html

Specifically, it says:

"FreeBSD, OpenBSD

The options SYSVSHM and SYSVSEM need to be enabled when the kernel is
compiled. (They are by default.) The maximum size of shared memory is
determined
by the option SHMMAXPGS (in pages). The following shows an example of how to
set the various parameters:

options SYSVSHM
options SHMMAXPGS=4096
options SHMSEG=256

options SYSVSEM
options SEMMNI=256
options SEMMNS=512
options SEMMNU=256
options SEMMAP=256
"

--Rick