Unable to connect to postgres in ubuntu

Question

I am trying to install postgresql on ubuntu. I followed the steps from http://hocuspokus.net/2008/05/install-postgresql-on-ubuntu-804/.

And on typing the command :

psql template1

I am getting the following 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"?

If you run /etc/init.d/postgresql status does it tell you its running? — Sam Dolan
– Sam Dolan, Commented Nov 28, 2011 at 9:17
If you ls -l /etc/init.d/ | grep postgres, do you see see anything? — Sam Dolan
– Sam Dolan, Commented Nov 28, 2011 at 9:23
Looks like you messed up some part of the installation process. Try removing then reinstalling. stackoverflow.com/questions/2748607/… may be helpfull. — Sam Dolan
– Sam Dolan, Commented Nov 28, 2011 at 9:30

caleb · Accepted Answer · 2013-07-22 17:14:04Z

1

The problem for me was that I had previously installed version 9.1, and 9.1 was still hogging the default port 5432. I was able to find this with the command:

root@labs:/home/caleb# /etc/init.d/postgresql status
9.1/main (port 5432): down
9.2/main (port 5433): online

So I was able to see that my 9.2 database was running on port 5433. So to connect, I had to explicitly specify port 5433:

psql -p 5433

answered Jul 22, 2013 at 17:14

caleb

2,87731 silver badges27 bronze badges

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

Comments

vijikumar · Accepted Answer · 2012-01-19 11:33:33Z

0

try the following

psql template0

answered Jan 19, 2012 at 11:33

vijikumar

1,82512 silver badges16 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:34:11Z

0

what resolved this error for me was deleting a file called postmaster.pid in the postgres directory. please see my question/answer using the following link for step by step instructions. my issue was not related to file permissions:

psql: could not connect to server: No such file or directory (Mac OS X)

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Nov 26, 2012 at 21:22

FireDragon

9,3854 gold badges30 silver badges35 bronze badges

Comments

Hrishikesh -Rishi- Choudhari · Accepted Answer · 2013-05-15 18:24:00Z

0

You can also get in the CLI via this command:

psql -U postgres -p 5432 -h localhost

answered May 15, 2013 at 18:24

Hrishikesh -Rishi- Choudhari

12.6k18 gold badges64 silver badges75 bronze badges

Comments

Dhanalal Bhardwaj · Accepted Answer · 2016-09-22 15:10:09Z

0

This should solve the error,

make a symbolic link to the /tmp/.s.PGSQL.5432:

sudo ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432

Thanks to this post

answered Sep 22, 2016 at 15:10

Dhanalal Bhardwaj

1611 silver badge4 bronze badges

Collectives™ on Stack Overflow

Unable to connect to postgres in ubuntu

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related