From: Frank Brendel <Frank.Brendel@eurolog.com>
To: pgsql-admin@postgresql.org
Subject: Re: Server doesn't listen error
Date: Fri, 4 Mar 2011 13:09:00 +0100
Message-ID: <55FFF8CD182C864DA8F1C9BA0D63AB8006F27D@elomail.eurolog.com> (raw)
In-Reply-To: <AANLkTinZRt+1USo=P-cSefACyVYbjsOJcYG8Nu_rq7Wp@mail.gmail.com>
References: <AANLkTikXzN0UX66bCdm+KC1eNuX_7A72zGDAYcDcbt6B@mail.gmail.com>
<55FFF8CD182C864DA8F1C9BA0D63AB8006F275@elomail.eurolog.com>
<AANLkTi=HN4hYArOmGM43dOa=S6LKfPnJiz9Vp=wN9gqL@mail.gmail.com>
<55FFF8CD182C864DA8F1C9BA0D63AB8006F279@elomail.eurolog.com>
<AANLkTikRb0e38Ff44oQmXdqYNTxnMPNCRJzM8Zsz=a+7@mail.gmail.com>
<55FFF8CD182C864DA8F1C9BA0D63AB8006F27C@elomail.eurolog.com>
<AANLkTinZRt+1USo=P-cSefACyVYbjsOJcYG8Nu_rq7Wp@mail.gmail.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.Brendel@eurolog.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.Brendel@eurolog.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.Brendel@eurolog.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@postgresql.org)
>>>>>> To make changes to your subscription:
>>>>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>>>>
>>>> --
>>>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>>
>>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Frank.Brendel@eurolog.com
Subject: Re: Server doesn't listen error
In-Reply-To: <55FFF8CD182C864DA8F1C9BA0D63AB8006F27D@elomail.eurolog.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox