From: Joshua D. Drake <jd@commandprompt.com>
To: Christopher Petrilli <petrilli@gmail.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Tomeh, Husam <htomeh@firstam.com>
Cc: PgSQL ADMIN <pgsql-admin@postgresql.org>
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date: Wed, 12 Jan 2005 17:34:42 -0800
Message-ID: <41E5D032.1050702@commandprompt.com> (raw)
In-Reply-To: <59d991c405011216274c899584@mail.gmail.com>
References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com>
<200501130100.32307.peter_e@gmx.net>
<59d991c405011216274c899584@mail.gmail.com>
>>The current recommendation, which is reflected in the installation
>>instructions, is to install the software as root and to use the
>>postgres user for the database files. The advice seen elsewhere in
>>this thread to use the postgres user also for the software files is
>>wrong.
>>
>>
>
>As a security professional, why would the root user need to be
>involved in the ownership of PostgreSQL?
>
The root does not need to be involved. You don't even
have to be root to install it ;). The only possible reason
I can come up with is that if the root user (or any other
user for that matter) owns the installation files, then
the postgres user would not be able to accidently delete
something.
Sincerely,
Joshua D. Drake
> I see no reason for this,
>but perhaps I'm missing something important.
>
>Chris
>
>
--
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
Attachments:jd.vcf (text/x-vcard, 283B) download
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:jd@commandprompt.com
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, petrilli@gmail.com, peter_e@gmx.net, htomeh@firstam.com
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
In-Reply-To: <41E5D032.1050702@commandprompt.com>
References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com> <200501130100.32307.peter_e@gmx.net> <59d991c405011216274c899584@mail.gmail.com> <41E5D032.1050702@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox