Skip site navigation (1) Skip section navigation (2)

Re: "pg_ctl: cannot be run as root"

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "pg_ctl: cannot be run as root"
Date: 2008-02-04 12:51:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

On Montag, 4. Februar 2008, Stefan Schwarzer wrote:
| I installed postgres without creating another postres user/admin than
| myself, as there is no other user on my machine and it's only for
| testing purposes.
| But strange enough, I only can start the postgres server from time to
| time, normally when I have freshly restarted the machine. Now for
| example, I did some changes to the postgresql.conf file, and when
| trying to restart the postgres server, I get this:
| gridmac7:~ schwarzer$ sudo /opt/local/lib/postgresql82/bin/pg_ctl -D
| Documents/data_postgres -l logfile start
| pg_ctl: cannot be run as root
| Please log in (using, e.g., "su") as the (unprivileged) user that will
| own the server process.
| What is this? Thanks for any advice,

PostgreSQL cannot be run as user root (that's what sudo is for). If you don't
have a seperate account for PostgreSQL, run it under your account (ie without
the "sudo").


Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- ----

In response to

pgsql-general by date

Next:From: pobox@verysmall.orgDate: 2008-02-04 13:02:14
Subject: Re: PGSQL ERROR: FATAL: terminating connection due to administrator command
Previous:From: Gregory StarkDate: 2008-02-04 12:34:49
Subject: Re: [OT] "advanced" database design (long)

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group