> 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
