AW: MacOS Application Security

Hi Joe,

please tell us more what you want to do with PG: Learning/Production/Production mission critical/small/medium/large.

Are you a Unix/Linux man or an Apple user?

How do you want to do your backups Time machine i guess,

Installing an App vs Homebrew are complete different worlds. Ist wise to do some investigation now before you proceed,

best,

Anton

Von: Joe Bloggs <joebloggs122021(at)gmail(dot)com>
Gesendet: Montag, 13. Dezember 2021 13:13
An: pgsql-admin(at)postgresql(dot)org
Betreff: MacOS Application Security

Hi,

From what I'm reading, you need to create a user with the bare minimum of rights to install and use PostgreSQL for security reasons. Question is, when you install PostgreSQL on a Mac using the Postgres.app and then you go to the data folder with the cluster and have a look at the permissions, my computer name user (I'm guessing an admin of some sort) is plastered across everything. Is the Postgres.app inherently less secure? Is using the Homebrew approach a better idea? Or should I just manually set permissions after the app is installed?

Thanks!