Postgresql error when I try psql

Question

i am getting this 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"?

What's the problem? I'm using postgresql 9.6 on Ubuntu 17.04 x64

The problem is that there is no server at the location you are trying to connect to, or that server is not accepting connections due to permissions, business, initialization, and incorrect connection attempt, or... — Joshua Drake
– Joshua Drake, Commented Aug 10, 2017 at 15:37

Ralf Stubner · Accepted Answer · 2017-08-10 15:31:53Z

1

Is the postgres deamon running, i.e. what is the output of

pg_lsclusters -h

? If it is not running, you can use

/etc/init.d/postgresql start

to start it.

answered Aug 10, 2017 at 15:31

Ralf Stubner

26.9k4 gold badges44 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1322133 · Accepted Answer · 2017-08-10 18:11:17Z

0

First Start the server:

../bin/pg_ctl start

then connect to the database

psql dbname

answered Aug 10, 2017 at 18:11

user1322133

Collectives™ on Stack Overflow

Postgresql error when I try psql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related