Postgres Pro
Downloads
Home   >   mailing lists

Thread: MacOS Application Security

MacOS Application Security

From
Joe Bloggs
Date:
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!

AW: MacOS Application Security

From
"Dischner, Anton"
Date:

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?

 

Thanks!