From: Dawid Kuroczko <qnex42@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date: Thu, 13 Jan 2005 13:06:40 +0100
Message-ID: <758d5e7f05011304065d7e56a0@mail.gmail.com> (raw)
In-Reply-To: <41E5FE80.8080402@commandprompt.com>
References: <4001DEAF7DF9BD498B58B45051FBEA650207AAD3@25exch1.vicorpower.vicr.com>
<41E5FE80.8080402@commandprompt.com>
On Wed, 12 Jan 2005 20:52:16 -0800, Joshua D. Drake
<jd@commandprompt.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: qnex42@gmail.com
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
In-Reply-To: <758d5e7f05011304065d7e56a0@mail.gmail.com>
References: <4001DEAF7DF9BD498B58B45051FBEA650207AAD3@25exch1.vicorpower.vicr.com> <41E5FE80.8080402@commandprompt.com> <758d5e7f05011304065d7e56a0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox