psql: could not connect to server [ubuntu]

Question

Under the postgres user, I tried the psql command and I'm 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"

But when I run /usr/local/pgsql/bin/psql, it is working.

Is there anything wrong with my configuration?

@Milen, do you mean what is shown when I type the command psql? I already mentioned it above. — xxx
– xxx, Commented Sep 20, 2012 at 11:04

solaimuruganv · Accepted Answer · 2012-09-25 10:35:43Z

4

the above issue seems related to PostgreSQL default port no,

Change the port no in postgresql.conf file and restart the DB server. if u have changed the port while installing.

(OR)

instead of psql type full command like

 "psql -p 5432 -h localhost"

edited Sep 25, 2012 at 10:35

user1671630

answered Sep 20, 2012 at 14:21

solaimuruganv

30.4k1 gold badge22 silver badges23 bronze badges

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

Comments

Hrishikesh -Rishi- Choudhari · Accepted Answer · 2013-05-15 18:25:09Z

1

You could include the database user too:

psql -U postgres -p 5432 -h localhost

answered May 15, 2013 at 18:25

Hrishikesh -Rishi- Choudhari

12.6k18 gold badges64 silver badges75 bronze badges

Comments

wangxiaolei · Accepted Answer · 2017-06-12 11:17:36Z

0

Did you reinstall the postgresql-9.6.3 ?

You need to uninstall postgresql completely

sudo apt-get --purge autoremove postgresql*

sudo apt install postgresql-9.6

answered Jun 12, 2017 at 11:17

wangxiaolei

415 bronze badges

Collectives™ on Stack Overflow

psql: could not connect to server [ubuntu]

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related