cant connect to localhost:5432 (but unix socket ok)

From: Joao Miguel Ferreira <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: cant connect to localhost:5432 (but unix socket ok)
Date: 2021-02-04 14:20:10
Message-ID: CALyyT7TQMb2K-9+ydKaRUc-7gBWSvGgzaoTFeE0M7Qq1QmdWog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

My database is not listening on TCP/localhost, desptite it is listening on
the unix socket. How can I investigate this?

I could have done something that is out of my understanding because I have
been loading some big pg_dumpall files that might contain administrative
changes that I am not fully aware of.

Here are some details about the connection issue:

root(at)deb10tp:~# id
uid=0(root) gid=0(root) groups=0(root)
root(at)deb10tp:~# su postgres
postgres(at)deb10tp:/root$ id
uid=116(postgres) gid=126(postgres) groups=126(postgres),125(ssl-cert)
postgres(at)deb10tp:/root$ cd /
postgres(at)deb10tp:/$ psql -h localhost
psql: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
postgres(at)deb10tp:/$ psql
psql (11.9 (Debian 11.9-0+deb10u1))
Type "help" for help.
postgres=#

Thank you
Joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2021-02-04 14:26:27 Re: cant connect to localhost:5432 (but unix socket ok)
Previous Message Laurenz Albe 2021-02-04 11:56:04 Re: when is useful min_wal_size?