From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ishan Joshi <Ishan(dot)Joshi(at)amdocs(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: idle_in_transaction_session_timeout not getting log in PG v12.2 |
Date: | 2020-05-19 17:13:56 |
Message-ID: | 8cbc8fbd-fbb4-ec0d-5fbe-3b29d0ab1552@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 copy the 11 *.conf files over and did you restart the 12
> server after? --> copy and restart the server 12
>
> 4) What is being logged to the file e.g. connections/disconnects, etc?
> --> yes these are getting logged
Just an FYI it worked on 12.2 and 12.3 instances on my machines:
--2020-05-19 10:01:22.489 PDT-0LOG: parameter
"idle_in_transaction_session_timeout" changed to "30s"
[unknown]-[unknown]-2020-05-19 10:01:46.970 PDT-0LOG: connection
received: host=[local]
[unknown]-aklaver-2020-05-19 10:01:46.971 PDT-0LOG: connection
authorized: user=aklaver database=task_manager application_name=psql
psql-aklaver-2020-05-19 10:02:22.869 PDT-0FATAL: terminating connection
due to idle-in-transaction timeout
psql-aklaver-2020-05-19 10:02:22.869 PDT-0LOG: disconnection: session
time: 0:00:35.899 user=aklaver database=task_manager host=[local]
>
> Thanks & Regards,
>
> Ishan Joshi
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Santhosh Kumar | 2020-05-19 17:25:05 | Clarification relation logical replication |
Previous Message | Santhosh Kumar | 2020-05-19 17:09:20 | Configuring more than one hot standby server |