Обсуждение: Can't start Pgsql 7.1 on FreeBSD 4.2

 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?

--
 In theory, there is no difference between theory
and practice. In practice, however, there is.
 - Albert Einstein

Kurt Seel <kseel@utcorp.com> writes:
>  Postmaster spits out this :
> IpcMemoryCreate: shmget(key=5432001, size=1236992, 03600) failed: Cannot
> allocate memory

If you try, say, -N 8 -B 16 does it start?

I'm betting 1236992 bytes is larger than your kernel's limit on shared
memory segment size.  You can certainly raise that limit, but I don't
know just how that's done on FreeBSD.

            regards, tom lane

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