I run this code as root:
/usr/local/bin/postgres -D /usr/local/pgsql/data
However it gives this error;
"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 server.
How can I login into PostgreSQL? Isn't it possible to use it with root user?
Some notes: This is PostgreSQL 9.4 (beta, but 9.3 gives me same error) on FreeBSD 10. PostgreSQL was installed via Ports. I think I have a "pgsql" user because it said
===> Registering installation for postgresql94-server-9.4.b3 ===> Creating users and/or groups. Using existing group 'pqsql'. Using existing user 'pqsql'.