> 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.brodziak@xxxxxxxxx>: >> 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.brodziak@xxxxxxxxx>: >>> 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.Brendel@xxxxxxxxxxx>: >>>>> 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.Brendel@xxxxxxxxxxx>: >>>>>>> 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.Brendel@xxxxxxxxxxx>: >>>>>>>>> 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.Brendel@xxxxxxxxxxx>: >>>>>>>>>> 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@xxxxxxxxxxxxxx) >>>>>>>>>> To make changes to your subscription: >>>>>>>>>> http://www.postgresql.org/mailpref/pgsql-admin >>>>>>>>>> >>>>>>>> -- >>>>>>>> Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) >>>>>>>> To make changes to your subscription: >>>>>>>> http://www.postgresql.org/mailpref/pgsql-admin >>>>>>>> >>>>>> -- >>>>>> Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) >>>>>> To make changes to your subscription: >>>>>> http://www.postgresql.org/mailpref/pgsql-admin >>>>>> >>>>> >>>> -- >>>> Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) >>>> 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" >> > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
