Re: Permission Problems:-)?

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@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.

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