DIGIT-ARC read-only archive · snapshot: July 23, 2026

POSTGRESQL ....... HOW TO RUN ??

2 posts · originally from https://geek.digit.in/community/threads/postgresql-how-to-run.17645/

mediator
mediator Original post #1
Oct 27, 2005 at 2:49 PM
I have FC4 and usually work on mysql, but I wanna experience postgresql too.
I started postgresql daemon but when executed 'postgres' it said ..

"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise. See the documentation for
more information on how to properly start the serv

When i tsrat postgres with normal user it says....

postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.


What to do??
desertwind
Oct 29, 2005 at 3:00 AM
normally it is /usr/local/pgsql/data.
start the server using the following command.
Code:
$ postmaster -D /usr/local/pgsql/data
Have PGSQL manuals here

You may find several answers regarding runtime environment here