macOS Catalina - postgreSQL - sysctl.conf still relevant?

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

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?


2 Answers

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

Add your own answers!

Related Questions

Problems loading pgAudit library on Postgres 12.2

2  Asked on October 28, 2021 by ivanovich


How to start Neo4j on Azure

1  Asked on October 28, 2021 by david-a-stumpf


Mongodb 4.2 Brute Force Defense

0  Asked on October 28, 2021 by darii-petru


Bridging Table Properties

2  Asked on October 28, 2021 by zv426


Using Postgres param in a function

1  Asked on October 28, 2021 by ovatsug25


Cannot access MYSQL safe mode using skip-grant-tables on Windows

0  Asked on October 28, 2021 by augustus-buckman


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP