PostgreSQL connection timeout

Question

I am using a desktop application with PostgreSQL database server. When I am not using application for 10 to 20 minutes continuously, the database connection is dropped. And I am using PostgresqlJDBC for database connection.

Please help me on this to database connection time out.

Thanks.

Solution

Sounds like you are connected via a stateful connection tracking router/firewall that has a short connection tracking timeout. Sounds like you need to enable keepalives.

Take a look at the tcp_keepalives_interval and tcp_keepalives_idle parameters.

You can also request keepalives client-side in the JDBC driver; see the pgJDBC docs.

Comments

[Prakki]

Thank you. I will look into pgJDBC docs. Can you please tell me the (best and optimized) values for both the parameters?

[Craig Ringer]

If there was a single value that was right for everybody, it would not be a parameter. It depends on your environment - how often the timeouts occur, etc.