From: | Ishan Joshi <Ishan(dot)Joshi(at)amdocs(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | idle_in_transaction_session_timeout not getting log in PG v12.2 |
Date: | 2020-05-19 09:08:32 |
Message-ID: | AM6PR0602MB33981FBE061CD537172D4D2C86B90@AM6PR0602MB3398.eurprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Team,
I have set idle_in_transaction_session_timeout on user level and it is set for 5 min. I can see after 5 min the session with "idle in transaction" state got killed and it log the details in postgresql log file with "FATAL: terminating connection due to idle-in-transaction timeout" in v11.5
But I have testing the same in v12.2, The session getting killed with state "idle in transaction" but the log is not generated in postgresql log file.
Is there any specific changes related to this for v12.2 or any additional parameters need to set for generating logs.
Thanks & Regards,
Ishan Joshi
This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service <https://www.amdocs.com/about/email-terms-of-service>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-05-19 13:40:43 | Re: Huge tables, trying to delete OID's taking 6+hours per table |
Previous Message | Andrus | 2020-05-19 08:26:51 | Re: Hot and PITR backups in same server |