From: Doug Quale <quale1@charter.net>
To: PgSQL ADMIN <pgsql-admin@postgresql.org>
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date: 12 Jan 2005 23:10:52 -0600
Message-ID: <87hdll9an7.fsf@charter.net> (raw)
In-Reply-To: <59d991c405011216274c899584@mail.gmail.com>
References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com>
<200501130100.32307.peter_e@gmx.net>
<59d991c405011216274c899584@mail.gmail.com>
Christopher Petrilli <petrilli@gmail.com> writes:
> As a security professional, why would the root user need to be
> involved in the ownership of PostgreSQL? I see no reason for this,
> but perhaps I'm missing something important.
A number of years ago some Unices experimented with installing system
binaries with owners other than root. Owner 'bin' was one common try.
Superficially this sounds good, but experience has shown that it is a
bad idea. I don't think anyone does this any longer.
Cracking root will compromise standard Unix security no matter who
owns the binaries. If system binaries are owned by a user other than
root, now you have at least two ids you must protect at all costs. By
making things more complex you've just managed to make your job of
maintaining security at least twice as hard as it would have been if
you had left things alone.
Obviously considerations are very different if setuid and setgid
programs are involved. Some modern Unices have more advanced security
models than the traditional Unix model, so binary ownership may be
handled differently in them as well.
Mark Twain understood this clearly all the way back in 1894:
"Put all your eggs in one basket, and WATCH THAT BASKET."
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: quale1@charter.net
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
In-Reply-To: <87hdll9an7.fsf@charter.net>
References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com> <200501130100.32307.peter_e@gmx.net> <59d991c405011216274c899584@mail.gmail.com> <87hdll9an7.fsf@charter.net>
* 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