Re: Installing PostgreSQL as "postgress" versus "root" Debate! - Mailing list pgsql-admin

From Goulet, Dick
Subject Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA650207AAD3@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to Installing PostgreSQL as "postgress" versus "root" Debate!  ("Tomeh, Husam" <htomeh@firstam.com>)
Responses Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Re: Installing PostgreSQL as "postgress" versus "root" Debate!
List pgsql-admin
Whatever, I'll keep root only for absolutely restricted use & install
under a separate user account.  Works just fine & it makes the auditors
& sysadmin feel better.


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone.bigpanda.com]
Sent: Wednesday, January 12, 2005 11:14 PM
To: Goulet, Dick
Cc: Peter Eisentraut; Tomeh, Husam; PgSQL ADMIN
Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root"
Debate!

On Wed, 12 Jan 2005, Goulet, Dick wrote:

>     You may well be on the development team, but you are wrong for
> one very important reason.  If the Postgresql executables are owned by
> root they execute with the priviledges of root.   Thereby any local

Not on any reasonable system unless installed setuid at which point I
don't think they'd run since I think the don't run as root code would
prevent it.

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Installing PostgreSQL as "postgress" versus "root"
Next
From: Bruce Momjian
Date:
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!