remote connection refused

[Yvon Thoraval <yvon.thoraval@xxxxxxxxx>]

I'd like to have a checklist upon what to do, what to investigate, when an external connection is refused.

if i connect by :

psql -h localhost -p 5432 -U yt mydb

it works as usual

however even locally but using the LAN address :

psql -h 192.168.0.20 -p 5432 -U yt mydb

i got a :

psql: could not connect to server: Connexion refusée
    Is the server running on host "192.168.0.20" and accepting
    TCP/IP connections on port 5432?

obviously I've verified by ping the computer is reachable.

something i suspect :

$ lal /var/run/postgresql
total 12
drwxrwsr-x  2 postgres postgres 140 nov.  19 09:53 .
drwxr-xr-x 26 root     root     900 nov.  19 09:45 ..
-rw-------  1 postgres postgres   6 nov.  19 09:53 9.1-main.pid
-rw-r--r--  1 postgres postgres   4 nov.  19 07:10 pgbouncer.pid
srwxrwxrwx  1 postgres postgres   0 nov.  19 09:53 .s.PGSQL.5432
-rw-------  1 postgres postgres  71 nov.  19 09:53 .s.PGSQL.5432.lock
srwxrwxrwx  1 postgres postgres   0 nov.  19 07:10 .s.PGSQL.6432

this the locked file :

.s.PGSQL.5432.lock

is that normal or not ?

something to say, i had a brutal shutdown due to over heating of my laptop recently.

on the pg_hba.conf i do have a bunch of IPV6 addresses allowing connection then i don't think the prob comes from here, but nevermind...

in such  a situation what is your checklist in order to find what I've missed ?

--

Yvon