Note that if you use pg_ctl and the $PGDATA var to point to the data dir, then you'll need to
su - postgres i.e. use the - to inherit the postgres users environment. On Thu, 31 Jul 2003, Marvin wrote: > You don't have to LOGOUT and LOGIN again as another user, > you just do: # su <user> > > #su postgres > > The postgres must exist and this is who will own the database. > > Regards, > > > MAGO > > -------Mensaje original------- > > De: Daniel Gerardo Lucero Baylon > Fecha: Jueves, 31 de Julio de 2003 05:03:08 p.m. > A: [EMAIL PROTECTED] > Asunto: [ADMIN] Starting PostgreSQL server as root > > I installed PostgreSQL 7.3.4 on Red Hat Linux 8.0. > > When I tried to mount database (using initdb command), following error > appear: > > You cannot run initdb as root. Please log in as the (unprivileged) user that > will own the server process. > > I read at Postgre documentation, and I need to log on as another user and > strt > process. > > This is my problem, I check another services and processes as root user, if > I > use another user to manage Postgre, another appliactions crashes. > > Does exist a way to start Postgre as root? > > I appreciate some help. > > Best Regards > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > > . ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
