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