Re: Server doesn't listen error

Hello,

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?

2011/3/4 Frank Brendel <Frank(dot)Brendel(at)eurolog(dot)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(dot)Brendel(at)eurolog(dot)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(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>
>>
>>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> 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"