Idle connections / sessions

Oygun Josef <[email protected]> Wed, 12 Dec 2018 09:37:30 +0000

Newsgroups	gmane.comp.db.postgresql.pgadmin,gmane.comp.db.postgresql.jdbc,gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.general
Message-ID	<HE1PR0402MB3625F9C2E5735459D63DA27C93A70@HE1PR0402MB3625.eurprd04.prod.outlook.com>

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