From: Frank Brendel <Frank.Brendel@eurolog.com>
To: pgsql-admin@postgresql.org
Subject: Re: Server doesn't listen error
Date: Fri, 4 Mar 2011 11:46:29 +0100
Message-ID: <55FFF8CD182C864DA8F1C9BA0D63AB8006F279@elomail.eurolog.com> (raw)
In-Reply-To: <AANLkTi=HN4hYArOmGM43dOa=S6LKfPnJiz9Vp=wN9gqL@mail.gmail.com>
References: <AANLkTikXzN0UX66bCdm+KC1eNuX_7A72zGDAYcDcbt6B@mail.gmail.com>
<55FFF8CD182C864DA8F1C9BA0D63AB8006F275@elomail.eurolog.com>
<AANLkTi=HN4hYArOmGM43dOa=S6LKfPnJiz9Vp=wN9gqL@mail.gmail.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
>>
>
>
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: <55FFF8CD182C864DA8F1C9BA0D63AB8006F279@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