Thread: 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
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------- Fecha: Jueves, 31 de Julio de 2003 05:03:08 p.m. Asunto: [ADMIN] Starting PostgreSQL server as root 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 majordomo@postgresql.org) . | |||
IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Attachment
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: pgsql-admin@postgresql.org > 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 majordomo@postgresql.org) > > .