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

From: Dawid Kuroczko <qnex42(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date: 2005-01-13 12:06:40
Message-ID: 758d5e7f05011304065d7e56a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 12 Jan 2005 20:52:16 -0800, Joshua D. Drake
<jd(at)commandprompt(dot)com> wrote:
> >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.
> I don't argue the point of using root. I agree with you there.
> Just the point that if it is owned by root it executes as root.

But only if either setuid root or executed by root. Hey, on my
system even /bin/sh is owned by root; it would be funny of it
executed as root

I see one reason to use 'postgres' as the install user -- to give
access to psql binaries to group of users (say, members of
postgres group). But I think PostgreSQL's own permission
system is enough for the job. :)

Regards,
Dawid

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dick Davies 2005-01-13 12:20:41 Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Previous Message Gémes Géza 2005-01-13 11:39:00 Re: Installing PostgreSQL as "postgress" versus "root" Debate!