On 8/29/13 10:18 PM, Scott Marlowe wrote:
> On Thu, Aug 29, 2013 at 12:09 PM, CS DBA <cs_dba at consistentstate.com> wrote:
>> All;
>>
>> I have a 35GB table that we are trying to add to a replication set.
>> The connection keeps timing out, we've changed the system keep alive to
>> every 30minutes
> Are you by chance running an older version of postgresql that tries to
> renegotiate ssl connections all the time? We had this problem on early
> 8.4 and had to turn off ssl connections to fix it.
>
No, we're on 9.2

However, once we changed the CentOS keepalive value to 30min the 
operation was successful