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

Status
Not open for further replies.

mediator

Technomancer
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

Cyborg Agent
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
 
Status
Not open for further replies.
Top Bottom