Re: Server doesn't listen error

> output form psql:
>
> psql: could not connect to server: Connection refused (0x0000274D/10061)
> Is the server running on host "10.10.128.145" and accepting
> TCP/IP connections on port 5432?
>
Ok, seems that the server is up but either it is the wrong IP address or
something is blocking us.

Firstly check the IP address on the server:
# ifconfig | grep inet

and secondly if I remember right, Ubuntu configures a standard firewall.
Please run the following iptables command on the server and on the
client and post the output:
# iptables -L

> 2011/3/4 Frank Brendel<Frank(dot)Brendel(at)eurolog(dot)com>:
>>> 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
>>>>
>>>
>> --
>> 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
>>
>
>