Re: Server doesn't listen error

> The netstat command output:
> tcp 0 0 0.0.0.0:5432 0.0.0.0:*
> LISTEN 13040/postgres
> tcp6 0 0 :::5432 :::*
> LISTEN 13040/postgres
>
Ok, the server is listening.

So what is the output of
# psql -h <your_database_ip>

E.g. if you can't connect you should see something like this

psql: could not connect to server: No route to host
Is the server running on host "x.x.x.x" and accepting
TCP/IP connections on port 5432?

Please post the output of the psql command.

> 2011/3/4 Frank Brendel<Frank(dot)Brendel(at)eurolog(dot)com>:
>> Hi Łukasz,
>>
>> is postgres really listening on all addresses?
>>
>> Please run the following command on your postgres server and post the
>> output:
>> # netstat -nltp | grep postgres
>>
>> And what is the error message when you try to connect with
>> # psql -h<your_database_ip>
>>
>>
>> Regards
>> Frank
>>
>> Am 04.03.2011 07:53, schrieb Lukasz Brodziak:
>>> Hi,
>>>
>>> I have a problem with PostgreSQL 8.2.4 I've installed it on Ubuntu
>>> configured to listen to all addresses started and still can't add the
>>> server to pgAdmin on a remote machine neither can I connect through my
>>> own app. All the credentials are ok, there is no NAT (it's LAN),
>>> firewall or antivirus.
>>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>
>