remote connection refused

From: Yvon Thoraval <yvon(dot)thoraval(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: remote connection refused
Date: 2012-11-19 12:08:21
Message-ID: CAG6bkBygJPQfpK3iTbYQXUYnHZwpViX-hOC+0zhatWTfJFNOAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin French 2012-11-19 12:17:41 Re: remote connection refused
Previous Message Benedikt Grundmann 2012-11-19 10:56:14 How to upgrade postgres 8.4 -> 9.1 contrib?