When installing PostgreSQL via MacPorts (and I assume via other means too), a
postgres:postgres user/group is created. Are there any reasons why this user/group is needed?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
The reason is that it is wise to run the database processes under a separate account. At least one advantage of this is that the OS processes as safer in the case of the database server being hacked. On the other side the database related files are safer from the 'normal' user accounts too - the PostgreSQL cluster (or at least its data) is relatively easy to destroy with a well-aimed single-file deletion.
If you check your