psql: could not connect to server on Linux

Asked Jan 21 '17 at 04:36

Active Jan 21 '17 at 06:58

Viewed 1,539 times

I installed PostgreSQL on Linux, how is indicated in Debian Wiki

After installation I run the following commands:

# su - postgres
$ psql

And I got 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 "/tmp/.s.PGSQL.5432"?

I found I solutions, but for Mac

Postgres could not connect to server https://dba.stackexchange.com/questions/75214/psql-could-not-connect-to-server-no-such-file-or-directory

How can I solve this issue in Linux?

Distribution details:

Distributor ID : Debian
Description    : Debian GNU/Linux 8.7 (jessie)
Release        : 8.7
Codename       : jessie

PostgreSQL     : 9.4

edited Jan 21 '17 at 06:58

jignesh Vadadoriya

3,244
3
18
29

asked Jan 21 '17 at 04:36

gvd

1,482
6
32
58

Is your environment set properly? What does `env | grep '^PG'` show? – codeforester Jan 21 '17 at 04:42
Nothing, may it be the problem? How can I solved? – gvd Jan 21 '17 at 04:44
Please see this page: https://www.postgresql.org/docs/9.1/static/libpq-envars.html – codeforester Jan 21 '17 at 04:46
Check if PostgreSQL service is running: http://stackoverflow.com/questions/7975414/how-to-check-status-of-postgresql-server-mac-os-x – codeforester Jan 21 '17 at 04:48
Yes, It is running. – gvd Jan 21 '17 at 04:51
You will find your answer in the related post I pasted above. – codeforester Jan 21 '17 at 04:59
I followed the steps, but I continue getting the error... – gvd Jan 21 '17 at 05:57
What do you get for `pg_ctl status`? What is the value of the parameters `unix_socket_directories` and `listen_addresses` in `postgresql.conf`? Is there a file `/tmp/.s.PGSQL.5432` on your computer? What do you get if you `telnet localhost 5432`? – Laurenz Albe Jan 23 '17 at 09:38
Sorry for the late late late time to response. I found that the problem is that PostgreSQL is not adding paths to enviromental variables when login to psql user. – gvd Mar 07 '17 at 02:21

psql: could not connect to server on Linux

0 Answers0