PostgreSQL, idle connections and firewalls
I recently had a problem where an entire website goes down from nothing, I checked the Apache logs, the application server logs and no big exceptions has been found.
After check the postgres database logs and few hours of searches on the web I finally could think in a small possibility, the firewall closing idle connections opened by application servers, so I decided to set the tcpKeepAlive property on JDBC connection, after that the issue seens to be gone.
I hope this post may be useful for someone