Re: [GENERAL] pg_xlog on a hot_standby slave filling up

> On Jun 19, 2015, at 7:50 AM, Christoph Berg <cb(at)df7cb(dot)de> wrote:
>
> Re: To Jeff Frost 2015-06-18 <20150618105305(dot)GA22374(at)msg(dot)df7cb(dot)de>
>>> I believe setting the ssl renegotiation limit to 0 made it stop. Can you confirm?
>>
>> I've configured that, we'll see later today.
>
> 0 makes it stop.
>
>>> Have you been able to reproduce synthetically?
>>
>> No. I managed to make the test setup leak one file when the slave
>> server was restarted, but atm it doesn't reconnect/barf every 512MB.
>> I'm probably still missing some parameter. (sslcompression=0 was the
>> first I tried...)
>
> (Still no success there.)

I had thought it was fixed on 9.2 by a recent update (not the last 3, but the one before) as it seemed to stop doing this, but then it started again after a few days, so there may be some large amount of transactions required before the funny business begins.

I would really love to deliver a self contained test case, but I tried for a few days unsuccessfully to reproduce it, but I still see it happening on 9.4.4 and 9.2.13, but not on all servers. :-/