iconara / bigshift

A tool for moving tables from Redshift to BigQuery
BSD 3-Clause "New" or "Revised" License
65 stars 10 forks source link

Set TCP keepalive options on the PG connection #9

Closed iconara closed 8 years ago

iconara commented 8 years ago

With really long running queries the TCP connection might otherwise time out. See http://stackoverflow.com/questions/26290382/long-running-redshift-transaction-from-ruby

TCP_KEEPIDLE is not available on OS X, but on Linux, so it is set conditionally.

This should solve #5.