I am trying to start clouder-scm-server-db after installing hadoop with cloudera manager.
[root@hostname ~]# service cloudera-scm-server-db restart
pg_ctl: no server running
DB initialization done.
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
When tried to start pg_ctl we are getting below error.
[root@hostname~]# /usr/pgsql-9.4/bin/postgres -c '/usr/pgsql-9.4/bin/pg_ctl start -D /var/lib/pgsql/9.4/data/ -l serverlog'
"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.