Was chasing a failure in a Postgres client where the connection is lost after 90 minutes. Both client and db are on Windows. Routers track connections they see in a local state table for routing…

HNasr's resource offers insights, tutorials, and resources for developers and technology enthusiasts. Readers can learn about programming languages, web development, and software engineering best practices. With articles, tutorials, and code snippets, HNasr provides  guidance and expertise for exploring new technologies and advancing technical skills.

Hussein Nasser

A Postgres client experienced connection failures after 90 minutes of inactivity due to a Cisco router's idle timeout setting. The router dropped the connection after 60 minutes of no data transmission as its default configuration. Adjusting the tcp_keepalives_idle setting in Postgres to send keep alive messages before the router's idle timeout can prevent such disconnections. The post emphasizes the need for understanding backend and database interactions for effective troubleshooting.

Postgres failure caused by a Cisco router