Re: Server doesn't listen error

> One more thing can anyone point me to contrib for postgresql 8.2 the
> default intalling from ap-get is for 8.4.
From where do you have your 8.2 ubuntu package?
Or get it from the 8.2 sources.

I assume you read
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy ?

> 2011/3/4 Lukasz Brodziak<lukasz(dot)brodziak(at)gmail(dot)com>:
>> Ok, I want to marry Your bones :) it was the firewall but strange
>> thing is that I managed to get the connection to work with WIndows
>> remote machine but with linux I had to turn off the firewall.
>>
>> 2011/3/4 Lukasz Brodziak<lukasz(dot)brodziak(at)gmail(dot)com>:
>>> Hello,
>>>
>>> The ifconfig showed I was wrong about IP address yet still problem
>>> remains. The output of iptables on Ubuntu:
>>> Chain INPUT (policy ACCEPT)
>>> target prot opt source destination
>>>
>>> Chain FORWARD (policy ACCEPT)
>>> target prot opt source destination
>>>
>>> Chain OUTPUT (policy ACCEPT)
>>> target prot opt source destination
>>>
>>> The firewall is not blocking the port because I can connect to the
>>> Windows machine with PG installed on it.
>>>
>>> 2011/3/4 Frank Brendel<Frank(dot)Brendel(at)eurolog(dot)com>:
>>>>> I forgo to tell that client is a Windows machine so the iptables won't
>>>>> run on it.
>>>>>
>>>> But on the server it will.
>>>> So please post the output of the two commands and make sure that your
>>>> Windows firewall (if activated) doesn't block outgoing traffic to port 5432.
>>>>
>>>> I feel it in my bones it's your Windows firewall ;-)
>>>>
>>>>> 2011/3/4 Frank Brendel<Frank(dot)Brendel(at)eurolog(dot)com>:
>>>>>>> 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
>>>>>>>>
>>>>>> --
>>>>>> 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
>>>>
>>>
>>>
>>> --
>>> Łukasz Brodziak
>>> "What if everyting around You isn't quite as it seems,
>>> What if all the world You think You know is an inelaborate dream
>>> When You look at Your reflection is that all you want it to be
>>> What if You could look right through the cracks
>>> Would You find Yourself...... Find Yourself afraid to see"
>>>
>>
>>
>> --
>> Łukasz Brodziak
>> "What if everyting around You isn't quite as it seems,
>> What if all the world You think You know is an inelaborate dream
>> When You look at Your reflection is that all you want it to be
>> What if You could look right through the cracks
>> Would You find Yourself...... Find Yourself afraid to see"
>>
>
>