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 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to