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.

I know its a desktop-app but beside this: using Tomcats JNDI datasources its the XML-Parameter <Resource ... maxWait="1" ... > for connection. I also use a Map<Session,Exception> to log where sessions has never closed. — Grim
– Grim, Commented Feb 17, 2015 at 7:06

Craig Ringer · Accepted Answer · 2014-03-10 09:44:25Z

4

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.

answered Mar 10, 2014 at 9:44

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prakki Over a year ago

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

Craig Ringer Over a year ago

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.

Collectives™ on Stack Overflow

PostgreSQL connection timeout

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related