On Sat, May 8, 2021 at 7:55 AM Vijaykumar Jain < [email protected]> wrote:
> Why do you want to increase that timeout ? > I hope you are aware long idle in transactions connections would delay > vacuuming and result in much larger bloats and slow down the db over period > of time. > You need to upgrade and push using the reasons that these are not > supported. > asking for workarounds around an unsupported version will only increase > headaches in the future. > +1 > > > On Sat, May 8, 2021, 3:58 PM Atul Kumar <[email protected]> wrote: > >> ok, But what is the workaround of this parameter in postgres 9.5, ,I >> need to increase the time of "idle in transaction" transactions. >> >> >> >> >> >> Regards, >> Atul >> >> >> >> >> >> >> >> On 5/7/21, [email protected] <[email protected]> >> wrote: >> > >> > ----- Mensagem original ----- >> >> De: "Atul Kumar" <[email protected]> >> >> Para: "pgsql-general" <[email protected]> >> >> Enviadas: Sexta-feira, 7 de maio de 2021 3:34:44 >> >> Assunto: idle_in_transaction_session_timeout >> > >> >> Hi, >> > >> >> I have postgres 9.5 version running on my machine. >> > >> >> When I am trying to find out the parameter >> >> idle_in_transaction_session_timeout it is showing me below error: >> > >> >> postgres=# show idle_in_transaction_session_timeout; >> >> ERROR: unrecognized configuration parameter >> >> "idle_in_transaction_session_timeout" >> > >> >> I also checked postgresql.conf but even in this file there is no such >> >> parameter. >> > >> >> Please help me to find this parameter. >> > >> >> Regards, >> >> Atul >> > >> > idle_in_transaction_session_timeout first appears in v9.6[1] >> > >> > [1] https://www.postgresql.org/docs/9.6/runtime-config-client.html >> > >> > Luis R. Weck >> > >> >> >> -- Regards, Avinash Vallarapu +1-902-221-5976
