Question

Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

I installed PostgreSQL on Ubuntu, I can view psql version with command psql --version. but when I input comman sudo -i -u postgres, it shows 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”?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

The error means that the Postgres server is not running. Try starting it:

sudo systemctl start postgresql

I believe the service name is postgresql, but if that doesn’t work, try typing sudo systemctl start postgres and pressing tab to auto-complete.

Make sure that the server starts on boot:

sudo systemctl enable postgresql