From: Jamison, Kirk [mailto:k.jami...@jp.fujitsu.com] > socket_timeout (integer)
libpq documentation does not write the data type on the parameter name line. > Terminate any connection that has been inactive for more than the specified > number of seconds to prevent client from infinite waiting for individual > socket read operations due to dead connection. This can be used both as > a force global query timeout and network problems detector. A value of zero > (the default) turns this off. > > or > > Controls the number of seconds of connection inactivity to prevent client > from infinite waiting for individual socket read operations due to dead > connection. This can be used both as a force global query timeout and network > problems detector. A value of zero (the default) turns this off. The second one is better, but: * Just "connection inactivity" (i.e. the application hasn't submitted any request to the server for a long time) does not terminate the connection. * "due to dead connction" is not the cause for the timeout. If the timeout occurs, consider the connection dead (see keepalives_count). * Not restricted to "read" operation? Regards Takayuki Tsunakawa
