macOS 10.13.2 High Sierra PostgreSQL 10.1.1 I had installed PostgreSQL a few days before but not really used it yet. I've just this moment upgraded to Apple Mac High Sierra 10.13.2 and I noticed a couple of things. Firstly my Apple Mac booted up with an extra PostgreSQL user, that I haven't investigated yet. Also when I started Firefox, it refreshed a download page with the PostgreSQL installer, and this time (!) I thought I might read the README. It talks about Shared Memory settings and the need to edit a file `/etc/sysctl.conf`. I do not have such a file. I also ran `sysctl -a` whihc gave me a whole host of settings. It quotes a number of settings of which the equivalent on my machine are: kern.sysv.shmmax: 4194304
kern.sysv.shmall: 1024
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 8
kern.maxprocperuid: 2837
kern.maxproc: 4256
My machine is an ancient Apple Mac Pro which has had the firmware upgraded from 4.1 to 5.1 thus enabling me to upgrade the OS to the latest High Sierra without any hassles. My machine has a generous 32 Gb of RAM on board so presumably will be able to cope with any demands that PostgreSQL can throw at it. The question is do I need to change any settings to do with memory before I complete the reinstallation? and do I need to worry about the second user account called PostgreSQL on my machine? Thanks in advance, Carl Caulkett
... View more