Thread: Starting PostgreSQL server as root

Starting PostgreSQL server as root

From
Daniel Gerardo Lucero Baylon
Date:
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

Re: Starting PostgreSQL server as root

From
"Marvin"
Date:
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
 
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)

.
_________________________________________________________________
  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Attachment

Re: Starting PostgreSQL server as root

From
"scott.marlowe"
Date:
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)
>
> .