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