I want to close idle connection in postgresql and want to set idle_in_transaction_session_timeout. I log into postgresql and when entering show idle_in_transaction_session_timeout at prompt get the following error message:
[database]=> show idle_in_transaction_session_timeout;
and get the following error message:
ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeout"
If i enter [database]=> SET SESSION idle_in_transaction_session_timeout = 3000; get the following error message:
ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeout"
Where do consult and set this variable in posrgresql? Thank you.