Rich Shepard <rshepard@xxxxxxxxxxxxxxx> writes: > $ psql --host salmo --user rshepard --dbname bustrac > psql: error: could not connect to server: could not connect to server: Connection refused > Is the server running on host "salmo" (127.0.1.1) and accepting > TCP/IP connections on port 5432? > could not connect to server: Connection refused > Is the server running on host "salmo" (192.168.55.1) and accepting > TCP/IP connections on port 5432? > Yet, /tmp has .s.PGSQL.5432= and .s.PGSQL.5432.lock > and I can access all databases using psql; e.g., > $ psql jerrittmine > psql (12.2) > Type "help" for help. > You're on the right path here. The server is running on salmo (the local > host) and accepting connections on port 5432. At least, that's how I'm > seeing it. What you've got there is that Unix-socket connections work, but TCP connections do not. Check the server's listen_addresses setting. If that says to allow connections on these IP addresses, next check your kernel firewall. regards, tom lane
