Re: Installing PostgreSQL as "postgress" versus "root" Debate!

From: Christopher Petrilli <petrilli(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "Tomeh, Husam" <htomeh(at)firstam(dot)com>, PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date: 2005-01-13 00:27:51
Message-ID: 59d991c405011216274c899584@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 13 Jan 2005 01:00:31 +0100, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Tomeh, Husam wrote:
> > I've seen book that prefer installing PostgreSQL as root and another
> > one recommends otherwise by first creating a postgres account and
> > then installing it as postgres. In the Oracle world, you don't use
> > root to install the software. What is the best practice as far as
> > PostgreSQL goes?
>
> 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.

Chris
--
| Christopher Petrilli
| petrilli(at)gmail(dot)com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2005-01-13 00:31:51 Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Previous Message Peter Eisentraut 2005-01-13 00:00:31 Re: Installing PostgreSQL as "postgress" versus "root" Debate!