Re: psql: could not connect to server: No route to host - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: psql: could not connect to server: No route to host
Date
Msg-id CAOR=d=2moM9mry0XiepPKKYoY=ngf1wdGcA-aV3Fw1hrJYeR-w@mail.gmail.com
Whole thread Raw
In response to Fwd: psql: could not connect to server: No route to host  (Ricardo Benatti <rbenatti@gmail.com>)
List pgsql-admin
I'm assuming this is a reply that has the quoted two deep stuff in it
from the OP to you, Ricardo.

On Thu, Apr 26, 2012 at 5:49 AM, Ricardo Benatti <rbenatti@gmail.com> wrote:
>
>
> the port is listening in VM ?
>
>> netstat -nat
>>
>> Active Internet connections (servers and established)
>> Proto Recv-Q Send-Q Local Address           Foreign Address         State
>> tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN
>> tcp        0      0 127.0.0.1:3350          0.0.0.0:*               LISTEN
>> tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN
>> tcp        0      0 0.0.0.0:631             0.0.0.0:*               LISTEN
>> tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN

This doesn't show the port listening on an external interface, only the internal

> released access [ postgresql.conf ] for connections tcp ??
>
>> # - Connection Settings -
>>
>> #listen_addresses = '*'                 # what IP address(es) to listen on;

That line is still commented out.

Uncomment listen_addresses and restart the server and try again.

pgsql-admin by date:

Previous
From: Andrew Barinov
Date:
Subject: Configuring pg on os x lion
Next
From: raghu ram
Date:
Subject: Re: Configuring pg on os x lion