Re: Pgadmin III loses connection with remote database and then hangs for a long time.

On Sun, 2011-05-29 at 13:09 +1200, Tim Uckun wrote:
> >
> > And no switch between them? Usually, this kind of issues happens because
> > of a faulty firewall or switch.
> 
> I am sure there are lots of switches between me and the database. I
> live in New Zealand and the server is usually in the US usually a
> linode or rackspace node but sometimes it's also an EC2 Node.
> 
> This happens no matter where the database is.  There are no port
> forwards there is usually an iptables rule that says allow postgres
> access from my IP.
> 

You can play with the tcp parameters in postgresql.conf to make sure
your tcp line is alive.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com