On Sunday, February 9, 2025, Mukesh Tanuku <
mukesh.postgres@gmail.com> wrote:
idle_in_transaction_session_timeout = '1min'
idle_session_timeout = '5min'
I suspect our docs may need an update. They say you may include white space before the unit; it probably needs to be changed to “must”. I believe we’ve recently tightened up the parsing of literals in this area.
other way also, like below
idle_in_transaction_session_timeout = 60000
idle_session_timeout = 300000
If those give error messages regarding trailing junk something else must be going on.
we see these errors reporting in the logs after we enabled those parameters
log:
2025-02-10 04:17:19.156 GMT [2467573] ERROR: trailing junk after numeric literal at or near "1m" at character 43
2025-02-10 04:17:19.156 GMT [2467573] STATEMENT: SET idle_in_transaction_session_timeout = 1min
2025-02-10 04:17:19.845 GMT [2467575] ERROR: trailing junk after numeric literal at or near "1m" at character 43
2025-02-10 04:17:19.845 GMT [2467575] STATEMENT: SET idle_in_transaction_session_timeout = 1min
...
David J.
