On Thu, 13 Jan 2005 01:00:31 +0100, Peter Eisentraut <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])