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

[mediator]

I have FC4 and usually work on mysql, but I wanna experience postgresql too.
I started postgresql daemon but when executed 'postgres' it said ..

[b]"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]

normally it is /usr/local/pgsql/data.
start the server using the following command.

$ postmaster -D /usr/local/pgsql/data

Have PGSQL manuals here

You may find several answers regarding runtime environment here