Re: Cannot Access Remote Server

On Fri, Aug 19, 2011 at 01:09, Guillaume Lelarge <guillaume@lelarge.info> wrote:
> On Thu, 2011-08-18 at 20:41 -0500, Tom Browder 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).
...
> Any firewalls, routers that could block the connection?

> Have you tried to connect with psql from the same computer than pgAdmin?

Just tried--no contact.

I muddled around in my notes--had same trouble I now see with mysql
and had to open up its port with iptables.  I just tried the same
thing for postgresql and did:

# iptables -A INPUT -p tcp --destination-port 5432 -s x.x.x.x

where x.x.x.x is my external IP from my home network.  I restarted
postgresql just in case but no connection.

Ideas?

Thanks.

-Tom