Thread: Idle connections / sessions

Idle connections / sessions

From
Oygun Josef
Date:

Hi,

 

Is it possible to terminate idle connections/sessions automatically through a timeout in AWS or do I need to run a periodical cron job for this?

 

Postgres version: 9.6.6

Instance: db.t2.micro

RAM : 1GB

 

We are running a microservice architecture using docker with kubernetes and I can see that every pod on every node that has connected to the DB still has a idle connection as long as the node is still active even.

 

It is both PGAdmin and the PostgreSQL JDBC Driver that leaves open idle connections.

 

 

Josef Oygun