Обсуждение: 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

----- Mensagem original -----
> De: "Atul Kumar" <akumar14871@gmail.com>
> Para: "pgsql-general" <pgsql-general@lists.postgresql.org>
> 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 

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, luis.roberto@siscobra.com.br <luis.roberto@siscobra.com.br> wrote:
>
> ----- Mensagem original -----
>> De: "Atul Kumar" <akumar14871@gmail.com>
>> Para: "pgsql-general" <pgsql-general@lists.postgresql.org>
>> 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
>

On 2021-05-08 15:58:27 +0530, Atul Kumar 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.

What makes you think that there is an "idle in transaction" timeout in
9.5?

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"