From: | Raigo77(at)solo(dot)delfi(dot)ee (Raigo) |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Starting PostgreSQL 7.3.4 server with Webmin |
Date: | 2003-08-19 22:12:10 |
Message-ID: | 80df3db1.0308191412.3fa384ad@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I just installed PostgreSQL 7.3.4 (new default install) and setting up
Webmin to be able to administrate it. My question: what is the correct
command here for staring PostgreSQL server?
from command line (as root) I successfully did it with:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
but when I run it with Webmin I get:
Failed to start database server :
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.
in install documentation I have options:
1)/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
and
2)nohup /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data \
</dev/null >>server.log 2>&1 </dev/null &
the second one didn't even work from command line. What is the correct
way to do it?
also, I would be glad to read what is the command for starting
Postgres in bootup. can I use the same command?
thanks for all ideas.
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2003-08-19 22:35:14 | Re: Starting PostgreSQL 7.3.4 server with Webmin |
Previous Message | Juan F Diaz | 2003-08-19 21:32:12 | Installing plpgsql proc language |