Re: Installing PostgreSQL as "postgress" versus "root" Debate! - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date
Msg-id 41E68BDD.8070608@commandprompt.com
Whole thread Raw
In response to Re: Installing PostgreSQL as "postgress" versus "root" Debate!  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
>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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


Attachment

pgsql-admin by date:

Previous
From: "Goulet, Dick"
Date:
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Next
From: "Tomeh, Husam"
Date:
Subject: Re: Installing PostgreSQL as "postgress" versus "root"