On 5/19/20 8:07 AM, Ishan Joshi wrote:
Hi Adrian,
1) What OS and version and did it change between 11 and 12? --> it is
cent os 7 an both v11.5 and v12.2 are on same server.
2) How are you starting the server and did that change? --> through
systemctl start postgresql-12
3) When did you c
-
From: Adrian Klaver
Sent: Tuesday, May 19, 2020 8:28 PM
To: Ishan Joshi ; pgsql-gene...@postgresql.org
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
On 5/19/20 7:40 AM, Ishan Joshi wrote:
> Yes Adrian...!!!
Well then:
1) What OS and version and did it chan
19, 2020 8:28 PM
To: Ishan Joshi ; pgsql-gene...@postgresql.org
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
On 5/19/20 7:40 AM, Ishan Joshi wrote:
> Yes Adrian...!!!
Well then:
1) What OS and version and did it change between 11 and 12?
2) How are you
On 5/19/20 7:40 AM, Ishan Joshi wrote:
Yes Adrian...!!!
Well then:
1) What OS and version and did it change between 11 and 12?
2) How are you starting the server and did that change?
3) When did you copy the 11 *.conf files over and did you
restart the 12 server after?
4) What is being logg
Yes Adrian...!!!
Thanks & Regards,
Ishan Joshi
-Original Message-
From: Adrian Klaver
Sent: Tuesday, May 19, 2020 7:53 PM
To: Ishan Joshi ; pgsql-gene...@postgresql.org
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
On 5/19/20 7:12 AM, Ishan Joshi w
l Message-
From: Adrian Klaver
Sent: Tuesday, May 19, 2020 7:28 PM
To: Ishan Joshi ; pgsql-gene...@postgresql.org
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
On 5/19/20 2:08 AM, Ishan Joshi wrote:
> Hi Team,
>
> I have set idle_in_transaction_
logging_collector
on
Thanks & Regards,
Ishan Joshi
-Original Message-
From: Adrian Klaver
Sent: Tuesday, May 19, 2020 7:28 PM
To: Ishan Joshi ; pgsql-gene...@postgresql.org
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
On 5/19/20 2:08 AM, Ishan Joshi w
On 5/19/20 2:08 AM, Ishan Joshi wrote:
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
