pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
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 21:52:36 -0500
Message-ID: <4443.1105584756@sss.pgh.pa.us> (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:
> On Thu, 13 Jan 2005 01:00:31 +0100, Peter Eisentraut <peter_e@gmx.net> wrote:
>> 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?  I see no reason for this,
> but perhaps I'm missing something important.

The rationale is that the executables should not be owned by the
postgres user, so that they can't be corrupted/trojaned if someone
manages to break in via the database server.

This of course does not require that the executables be owned by root,
only by someone other than the daemon account you run the server under.

			regards, tom lane



view thread (48+ messages)  latest in thread

Message-ID: <4443.1105584756@sss.pgh.pa.us>
Permalink:  ../4443.1105584756@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/4443.1105584756@sss.pgh.pa.us

 · 

reply

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: tgl@sss.pgh.pa.us, petrilli@gmail.com, peter_e@gmx.net, htomeh@firstam.com
  Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
  In-Reply-To: <4443.1105584756@sss.pgh.pa.us>
  References: <C45835824D00A844BBD0F032D5CDED9212FBDC@pisgana01sxch01.ana.firstamdata.com> <200501130100.32307.peter_e@gmx.net> <59d991c405011216274c899584@mail.gmail.com> <4443.1105584756@sss.pgh.pa.us>

* 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