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(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