The default value about “idle_in_transaction_session_timeout” of PostgreSQL in CloudSQL?

[張懷倫]

I spent more time to figure out this problem, but get nothing. Have anyone know the answer ? 

Or teach me how to set the value "idle_in_transaction_session_timeout" of Postgres in CloudSQL.

Thanks for your help !!

[Yasser Karout (Cloud Platform Support)]

You can set idle_in_transaction_session_timeout on the session level in PostgreSQL 9.6 using SET [1]:

SET SESSION idle_in_transaction_session_timeout = '5min';

If you need this to be set at instance level, I recommend opening a Feature Request on the issue tracker website [2] so that the Cloud SQL Team can look into it as this flag is not implemented for Postgres in Cloud SQL [3]

The default value is 0 which disables the feature according to the Postgres docs [4]

[1] https://www.postgresql.org/docs/current/sql-set.html

[2] https://issuetracker.google.com/

[3] https://cloud.google.com/sql/docs/postgres/flags#list-flags-postgres

[4] https://www.postgresql.org/docs/9.6/runtime-config-client.html