Re: Cannot Access Remote Server

On Thu, Aug 18, 2011 at 16:33, Thom Brown <thom(at)linux(dot)com> wrote:
> On 18 August 2011 22:26, Tom Browder <tom(dot)browder(at)gmail(dot)com> wrote:
>>
>> I have a remote server running postgresql (9.0.4).  I have been able
>> to use the dbms via ssh and via phppgadmin.
>>
>> Now I would like to use pgadminIII but I cannot get the server
>> connection.  I am running the Ubuntu version og pgadmin (1.10.5).
>>
>> I have this setting in my postgresql.conf:
>>
>>  listen_addresses = '*'
>>
>> And these in my pg_hba.conf:
>>
>> local   all             all                                     md5
>> host    all             all             127.0.0.1/32            md5
>> host    all             all             ::1/128                 md5
>> host  all             admin        xxx.xxx.xxx.xxx/32         md5
>> host  all             postgres     xxx.xxx.xxx.xxx/32         md5
>>
>> where xxx.xxx.xxx.xxx is the external IP of my home network.
>>
>> I can ping my server fine.
>>
>> I appreciate any ideas.

[Sorry, I meant to add that but got distracted.]

> What message comes up when failing to connect?

The window shows:

connecting to server:5432 (grayed out)
(icon: time passing whil waiting...)

I give up and try to close the window and get

pgAdmin III is not responding...
[force quit][wait]

I wait and eventually get a message window that says:

Server doesn't listen

The server doesn't accept connections: the connection library reports
could not connect to server: Connection timed out Is the server running on
host "xxx.xxx.xxx.xxx" and accepting TCP/IP connections on port 5432?
...

I'm checking my logs...

I can't find anything unusual on my local hoist or the remote host.

Thanks.

-Tom