Re: Starting PostgreSQL server as root

From: "Marvin" <magosoft(at)gmx(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Starting PostgreSQL server as root
Date: 2003-07-31 23:08:52
Message-ID: 3F29A184.000001.03032@guaj215desa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-08-01 00:12:35 Re: Parallel transactions failing oddly
Previous Message Daniel Gerardo Lucero Baylon 2003-07-31 22:59:30 Starting PostgreSQL server as root