From: Frank Brendel <Frank.Brendel@eurolog.com>
To: pgsql-admin@postgresql.org
Subject: Re: Server doesn't listen error
Date: Fri, 4 Mar 2011 12:41:50 +0100
Message-ID: <55FFF8CD182C864DA8F1C9BA0D63AB8006F27C@elomail.eurolog.com> (raw)
In-Reply-To: <AANLkTikRb0e38Ff44oQmXdqYNTxnMPNCRJzM8Zsz=a+7@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>
> 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
>>
>
>
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: <55FFF8CD182C864DA8F1C9BA0D63AB8006F27C@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