Skip site navigation (1) Skip section navigation (2)

Re: Permission Problems:-)?

From: Jerome Lyles <susemail(at)hawaii(dot)rr(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission Problems:-)?
Date: 2004-01-28 03:22:37
Message-ID: 200401271722.37876.susemail@hawaii.rr.com (view raw or flat)
Thread:
Lists: pgsql-general
On Tuesday 27 January 2004 03:51 pm, Alvaro Herrera wrote:
> 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(at)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(at)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.

I stand corrected and it feels good:-).
Thanks for your excellent help Tom and Richard.
Sincerely,
Jerome


In response to

pgsql-general by date

Next:From: Christopher BrowneDate: 2004-01-28 04:58:15
Subject: Re: Looking for mail relays ...
Previous:From: Tom LaneDate: 2004-01-28 02:29:38
Subject: Re: Manually authenticating users in pg_shadow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group