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
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? |