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

On Wed, 12 Jan 2005 15:30:06 -0800, Tomeh, Husam <htomeh(at)firstam(dot)com> 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?

There is absolutely no reason to install as root. I always create a
user (for me, it's 'pgsql') and then run the installer as that user.
That does mean that the directory (/usr/local/pgsql/) must already be
created and owned (it's the home for my user).

The less done as root, the better.

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