Database Administrators Asked by Crashmeister on January 4, 2022
I had the following settings in /etc/sysctl.conf before Catalina:
# PostgreSQL Config for the MAC
kern.sysv.shmmax=2147483648
kern.sysv.shmall=524288
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.maxprocperuid=1024
kern.maxproc=2048
The Catalina install moved this file to the /Users/Shared folder as /etc is now considered private to macOS.
Are these settings still relevant for Catalina, and if so, where do they need to go?
Thx.
I ran into the same issue. I put the file back (at /etc/sysctl.conf) and it worked just like before (at least for setting kern.maxvnodes).
Answered by Russell Davis on January 4, 2022
You don't need the shared memory parameters any more, because PostgreSQL has been using POSIX shared memory for a while now.
Making sure that the PostgreSQL user can have enough open files is a good idea though.
Answered by Laurenz Albe on January 4, 2022
0 Asked on October 28, 2021
1 Asked on October 28, 2021
2 Asked on October 28, 2021 by ivanovich
1 Asked on October 28, 2021 by velocity
1 Asked on October 28, 2021 by pbarney
1 Asked on October 28, 2021 by xirt
1 Asked on October 28, 2021
2 Asked on October 28, 2021 by oren-a
1 Asked on October 28, 2021
1 Asked on October 28, 2021 by ovatsug25
1 Asked on October 28, 2021 by sunilgoswami
1 Asked on October 28, 2021
1 Asked on October 28, 2021
1 Asked on October 28, 2021 by rajesh-ranjan
0 Asked on October 28, 2021 by augustus-buckman
2 Asked on October 28, 2021 by alex-lo
5 Asked on October 28, 2021 by mk-singh
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP