Re: Permission Problems:-)?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Permission Problems:-)?
Дата
Msg-id 20040128015136.GA25132@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Permission Problems:-)?  (Jerome Lyles <susemail@hawaii.rr.com>)
Ответы Re: Permission Problems:-)?  (Jerome Lyles <susemail@hawaii.rr.com>)
Список 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 по дате отправления:

Предыдущее
От: "William Harazim"
Дата:
Сообщение: Re: Manually authenticating users in pg_shadow
Следующее
От: Brendan Jurd
Дата:
Сообщение: Update Default (was: Touch row ?)