Re: psql: could not connect to server: No route to host

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ricardo Benatti <rbenatti(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql: could not connect to server: No route to host
Date: 2012-04-27 20:50:38
Message-ID: CAOR=d=2moM9mry0XiepPKKYoY=ngf1wdGcA-aV3Fw1hrJYeR-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2012-04-28 04:51:39 Re: Configuring pg on os x lion
Previous Message Andrew Barinov 2012-04-27 19:22:25 Configuring pg on os x lion