I'm trying to set up a PostgreSQL server using the instructions found on here. I installed the package via apt-get install postgresql
and now I'm on the step:
sudo -u postgres psql postgres
which gives the error:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I'm guessing the server isn't running but I'm not sure how to start it. Any tips would be much appreciated.
UPDATE: Running service postgresql status
doesn't output anything, even after sudo service postgresql start
.
UPDATE #2: Running ps auxw | grep post
doesn't turn up anything either, so I'm guessing the server daemon isn't running.
apt-get install postgresql
, did you check that the installation actually was successful? Please report the output ofapt-cache policy postgresql postgresql-9.1
.