Skip site navigation (1) Skip section navigation (2)

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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,"Goulet, Dick" <DGoulet(at)vicr(dot)com>,Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,Peter Eisentraut <peter_e(at)gmx(dot)net>,PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Installing PostgreSQL as "postgress" versus "root"
Date: 2005-01-13 17:22:07
Message-ID: 20050113172207.GC13594@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Jan 13, 2005 at 08:06:05 -0800,
  "Tomeh, Husam" <htomeh(at)firstam(dot)com> wrote:
> So does that mean there's no security issue using the root account to
> install postrgeSQL as the first book indicated? Thanks.

This depends on who you trust. The install scripts could potentially do
bad things. Generally you will need to do at least some part of the
install process as root. It is also a good idea to install the binaries
using a different user (and root is fine if there aren't any setuid/setgid
binaries) than the database will run under so that database users can't
corrupt the binaries via untrusted languages or bugs.

In response to

pgsql-admin by date

Next:From: Christopher BrowneDate: 2005-01-13 17:26:04
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Previous:From: Scott MarloweDate: 2005-01-13 17:18:32
Subject: Re: Installing PostgreSQL as "postgress" versus "root"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group