Re: Permission Problems:-)? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Permission Problems:-)?
Date
Msg-id 20040128015136.GA25132@dcc.uchile.cl
Whole thread Raw
In response to Re: Permission Problems:-)?  (Jerome Lyles <susemail@hawaii.rr.com>)
Responses Re: Permission Problems:-)?  (Jerome Lyles <susemail@hawaii.rr.com>)
List pgsql-general
On Tue, Jan 27, 2004 at 03:08:23PM -1000, Jerome Lyles wrote:

> > I don't think so --- the postmaster will actively refuse to start if you
> > try to run it as root.  Better take another look at exactly what's
> > happening.
>
> Well two out of three isn't bad:-).  I'll let you be the judge:
> Running the postmaster as root:
>
> adriel@linux:~> su
> Password:
> linux:/home/adriel # /etc/init.d/postgresql start
> Starting PostgreSQL
> done

If you look closely at the script, you'll see that the postmaster is not
run as root, but rather under "su - postgres".  (You should be aware
that the start script is very different and separate from the postmaster
program.)  So Tom gets 3/3, and you will know sooner or later that he
scores 100% most of the time.

> postgres@linux:~> ps auxw | grep postgres
> postgres 18973  0.0  0.2 17960 2296 pts/3    S    14:47   0:00 /usr/bin/postmaster -D /var/lib/pgsql/data

See, this is not running as root.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)

pgsql-general by date:

Previous
From: "William Harazim"
Date:
Subject: Re: Manually authenticating users in pg_shadow
Next
From: Brendan Jurd
Date:
Subject: Update Default (was: Touch row ?)