On Thu, Feb 04, 2021 at 02:20:10PM +0000, Joao Miguel Ferreira wrote: > 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.
There are couple of potential issues: 1. it might listen on different port than 5432. What does "show port;" show in psql? 2. it could be that there is a firewall (weird, but possible) 3. it could be that it's listening on another address(es) than 127.0.0.1 / ::1 - what is output of "show listen_addresses;"? 4. Verify that it really does listen on something. As root run: ss -ntlp | grep postgres depesz > Here are some details about the connection issue: > root@deb10tp:~# id > uid=0(root) gid=0(root) groups=0(root) > root@deb10tp:~# su postgres > postgres@deb10tp:/root$ id > uid=116(postgres) gid=126(postgres) groups=126(postgres),125(ssl-cert) > postgres@deb10tp:/root$ cd / > postgres@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@deb10tp:/$ psql > psql (11.9 (Debian 11.9-0+deb10u1)) > Type "help" for help. > postgres=# > Thank you > Joao
