On Thu, Aug 18, 2011 at 16:33, Thom Brown <thom@linux.com> wrote:
> On 18 August 2011 22:26, Tom Browder <tom.browder@gmail.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