Re: Idle connections / sessions
Sorry but i don't know (i am not familiar with aws) Maybe this will help: If you want pg_terminator can run on postgresql server. Regards Thomas Le mer. 12 déc. 2018 à 12:20, Oygun Josef a écrit : > Hi, > > > > Sorry for that! > > > > Thank you for the answers, this is good but do you know if there is a way > do to it through AWS console with some kind of configuration instead? > > > > Reason for that is the we use terraform scripts to create and keep state > of our instances so pg_terminator would require me to add every new db > props to it. > > > > /Josef > > > > > > *Från:* Thomas Poty [mailto:thomas.p...@gmail.com] > *Skickat:* den 12 december 2018 11:11 > *Till:* pgsql-general@lists.postgresql.org > *Ämne:* Re: Idle connections / sessions > > > > Hi Josef, > > > > pg_terminator may help you. > > > > thomas > > > > Le mer. 12 déc. 2018 à 11:02, Fabio Pardi a écrit : > > Hi Josef, > > please avoid cross posting to multiple lists. > > I m not a developer, but I think that if you do not want idle connections, > you should terminate them on the side they have been created. > > If your application leaves the connection open, then you will notice idle > connections on Postgres when not in use. > > regards, > > fabio pardi > > On 12/12/2018 10:37, Oygun Josef wrote: > > 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* > > > > > >
Re: Idle connections / sessions
Hi Josef, pg_terminator may help you. thomas Le mer. 12 déc. 2018 à 11:02, Fabio Pardi a écrit : > Hi Josef, > > please avoid cross posting to multiple lists. > > I m not a developer, but I think that if you do not want idle connections, > you should terminate them on the side they have been created. > > If your application leaves the connection open, then you will notice idle > connections on Postgres when not in use. > > regards, > > fabio pardi > > > On 12/12/2018 10:37, Oygun Josef wrote: > > 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* > > > > >
Re: Idle connections / sessions
Hi Josef, please avoid cross posting to multiple lists. I m not a developer, but I think that if you do not want idle connections, you should terminate them on the side they have been created. If your application leaves the connection open, then you will notice idle connections on Postgres when not in use. regards, fabio pardi On 12/12/2018 10:37, Oygun Josef wrote: > > 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* > > >