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. -- 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) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings