CODEWITHSUNDEEP
postgresqlpostgresql-9.1
Prakki
Prakki

Reputation: 159

PostgreSQL connection timeout

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.

Upvotes: 4

Views: 23339

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324265

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.

Upvotes: 4

Related Questions