Re: BUG #16067: Failed system call was semget

On Sat, Oct 19, 2019 at 02:54:45PM +0000, PG Bug reporting form wrote:
>The following bug has been logged on the website:
>
>Bug reference:      16067
>Logged by:          chelsea lyu
>Email address:      chelsealyu@gmail.com
>PostgreSQL version: 11.5
>Operating system:   MacOS
>Description:
>
>running bootstrap script ... 2019-10-19 23:25:15.095 JST [51410] FATAL:
>could not create semaphores: No space left on device
>2019-10-19 23:25:15.095 JST [51410] DETAIL:  Failed system call was
>semget(5432226, 17, 03600).
>
>this is the code what I input, and then the problem is out.
>MacBook-Pro:~ raye$ initdb /usr/local/var/postgres -E utf8
>
>
>I also tried the code in the guide book of solving this question.
>RAYEdeMacBook-Pro:~ raye$ sysctl -w kern.sysv.shmmax
>kern.sysv.shmmax: 4194304
>RAYEdeMacBook-Pro:~ raye$ sysctl -w kern.sysv.shmmin
>kern.sysv.shmmin: 1
>RAYEdeMacBook-Pro:~ raye$ sysctl -w kern.sysv.shmmni
>kern.sysv.shmmni: 32
>RAYEdeMacBook-Pro:~ raye$ sysctl -w kern.sysv.shmseg
>kern.sysv.shmseg: 8
>RAYEdeMacBook-Pro:~ raye$ sysctl -w kern.sysv.shmall
>kern.sysv.shmall: 1024
>
>but nothing happened.
>it still cannot work.
>

I think you need to tweak kernel.sem, not the options for sysv shared memory.

Also, not a PostgreSQL bug, but an OS configuration issue ...


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services