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