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: > > > > [EMAIL PROTECTED]:~> 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. > > > [EMAIL PROTECTED]:~> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
