Re: Starting PostgreSQL server as root

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(at)postgresql(dot)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(at)postgresql(dot)org)
>
> .