Postgresql is the server running locally and accepting connection on Unix domain

Question

I am trying to install postgresql-9.5 or postgresql-9.6 on my ubuntu 16.04 or 14.04 machine, after following the installation process using below commands.

sudo apt-get install update
sudo apt-get install postgresql postgresql-contrib

But when I am trying to open psql from my terminal using below commands

sudo su postgres 
psql

every time its just showing.

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 have tried approximately 10 stackoverflow.com solutions but no success. Please help me out before I tear all my hairs :(

$ service postgresql status

● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese
   Active: active (**exited) since রবি 2017-03-12 21:45:56 BDT; 23min ago
  Process: 917 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
 Main PID: 917 (code=exited, status=0/SUCCESS)
    Tasks: 0
   Memory: 0B
      CPU: 0
   CGroup: /system.slice/postgresql.service

see this line carefully why exited ? Active: active (exited) since রবি 2017-03-12 21:45:56 BDT; 23min ago

First thing to check is the postgres logfile. Postgres fails to start up on (some) configuration errors, and reports this in the logfile, before exiting. — wildplasser
– wildplasser, Commented Mar 12, 2017 at 16:41

Gab · Accepted Answer · 2017-03-12 16:18:29Z

22

You can run the following command to check if postgresql is running:

service postgresql status

If PostgreSQL is not started you can start it with:

service postgresql start
service postgresql status

If it does not start properly, you can look at what is going on in the logs:

tail /var/log/postgresql/postgresql-9.6-main.log

You might have to run createdb to initialize a database (see https://www.postgresql.org/docs/current/static/app-createdb.html):

createdb demo

Update

If PostgreSQL is running when you do service postgresql status but you still can't connect, you should check if PostgreSQL is indeed running on port 5432 or another one with:

netstat -na | grep postgres

Update 2

Since the native packages on debian/ubuntu for PostgreSQL sucks, I advise you to install these instead: https://www.gab.lc/articles/install_postgresql_9-5_debian_ubuntu (replace 9-2 with 9-6).

edited Mar 12, 2017 at 16:18

answered Mar 12, 2017 at 16:06

Gab

3,5381 gold badge13 silver badges23 bronze badges

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

3 Comments

Gab Over a year ago

I added a port check to my answer, please let me know if it helps

A l w a y s S u n n y Over a year ago

netstat -na | grep postgres shows nothing on the terminal

Gab Over a year ago

ok I strongly advise you to remove the packages from debian and install the ones suggested in my "update 2"

A l w a y s S u n n y · Accepted Answer · 2020-02-04 00:52:01Z

8

This is how finally solved my issue after removing the existing postgresql version and directory

sudo apt-get --purge remove postgresql-*
sudo rm -Rf /etc/postgresql /var/lib/postgresql
sudo apt-get install postgresql

edited Feb 4, 2020 at 0:52

answered Mar 14, 2017 at 16:52

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

1 Comment

Jansen Simanullang Over a year ago

Straightforward answer that works. Thank you for writing.

Collectives™ on Stack Overflow

Postgresql is the server running locally and accepting connection on Unix domain

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related