Skip site navigation (1) Skip section navigation (2)

Cannot Access Remote Server

From: Tom Browder <tom(dot)browder(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Cannot Access Remote Server
Date: 2011-08-18 21:26:05
Message-ID: CAFMGiz-bVsHDQpZyGT1y8J1zwbS++6c-jcz7qoni+6ya3Yuv3w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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.

Best regards,

-Tom
Niceville, Florida, USA

Responses

pgadmin-support by date

Next:From: Thom BrownDate: 2011-08-18 21:33:58
Subject: Re: Cannot Access Remote Server
Previous:From: Guillaume LelargeDate: 2011-08-18 20:56:15
Subject: Re: query interminable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group