Re: Idle connections / sessions

2018-12-12 Thread Thomas Poty
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, >

SV: Idle connections / sessions

2018-12-12 Thread Oygun Josef
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

Re: Idle connections / sessions

2018-12-12 Thread Thomas Poty
ide 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 possibl

Re: Idle connections / sessions

2018-12-12 Thread Fabio Pardi
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 v

Idle connections / sessions

2018-12-12 Thread Oygun Josef
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