Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group