Problem
I am trying to run the command:
psqland I am getting the error:psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.orpsql : could not send startup packet : Broken Pipe.
Cause
The psql command is not designed to be run as root. The command can only be issued by a configured postgresql user.
Solution
Postgresql user accounts are not the same as regular Unix
accounts. A Unix account must be added to PostgreSQL with
thecreateusercommands by an existing postgresql user with proper
authorization. An initial privileged user is created when
"mkdev pgsql" is run.If you have not already run "mkdev pgsql" then please run it to create the initial privilaged postgresql user.
If "mkdev pgsql" has already been run then please su to the privileged user you have created and the run the "psql" command.