Re: Installing PostgreSQL as "postgress" versus "root" Debate!

>Those who dismiss this advice as my own imagination may want to check
>how other server packages are installed on their system.
>
>What user does sshd run under? Who owns /usr/sbin/sshd?
>
>What user does the MTA run under? Who owns the binaries?
>
>What user does Apache run under? Who owns the binaries?
>
>etc.
>
>
Peter is correct on this. Most daemon level items typically
run as their own user to protect the rest of the system.

Sincerely,

Joshua D. Drake

>On my system, the answer is sshd/postfix/www-data on the one side and
>root on the other. Therefore it is consistent to use postgres and root
>for PostgreSQL. If your system uses a different distribution of users,
>you may want to adjust the PostgreSQL installation accordingly. But
>note that this voids your warranty because it is not covered by the
>installation instructions. :)
>
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL