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@gmail.com>
Gesendet: Montag, 13. Dezember 2021 13:13
An: pgsql-admin@postgresql.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?