Hello,
I have an issue on a integrator process.
My connection with my postgres database seems closed.
I have the message below:
Cannot load data into table social_bulletin_ligne_habs: Server has closed the connection. </p> <p>Please check net_read_timeout/net_write_timeout/wait_timeout server variables. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_read_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information)
My problem is that I have added :
idle_in_transaction_session_timeout = 10000000
but nothing.
Do I need to add another parameter?
thank you
I have an issue on a integrator process.
My connection with my postgres database seems closed.
I have the message below:
Cannot load data into table social_bulletin_ligne_habs: Server has closed the connection. </p> <p>Please check net_read_timeout/net_write_timeout/wait_timeout server variables. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_read_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information)
My problem is that I have added :
idle_in_transaction_session_timeout = 10000000
but nothing.
Do I need to add another parameter?
thank you