<div dir="ltr">Hello Everyone,<div><br></div><div>I thought i got those cleanup event every 10 minutes, which is the default.</div><div>I desired another value for this parameter, but seems didn't work. I set them to 20 minutes.</div>
<div>How can i change the value for cleanup event on slon process?</div><div><br></div><div>config :</div><div>cleanup_interval="20 minutes"<br></div><div><div><br></div><div>related log :</div><div><div>NOTICE: Slony-I: log switch to sl_log_2 complete - truncate sl_log_1</div>
<div>CONTEXT: PL/pgSQL function "cleanupevent" line 100 at assignment</div><div>2014-08-14 17:46:23 EDTINFO cleanupThread: 0.060 seconds for cleanupEvent()</div></div><div><div>NOTICE: Slony-I: Logswitch to sl_log_1 initiated</div>
<div>CONTEXT: SQL statement "SELECT "_slony_example".logswitch_start()"</div><div>PL/pgSQL function "cleanupevent" line 102 at PERFORM</div><div>2014-08-14 17:57:18 EDTINFO cleanupThread: 0.005 seconds for cleanupEvent()</div>
</div><div><div>NOTICE: Slony-I: log switch to sl_log_1 still in progress - sl_log_2 not truncated</div><div>CONTEXT: PL/pgSQL function "cleanupevent" line 100 at assignment</div><div>2014-08-14 18:08:13 EDTINFO cleanupThread: 0.043 seconds for cleanupEvent()</div>
</div><div><div>NOTICE: Slony-I: log switch to sl_log_1 complete - truncate sl_log_2</div><div>CONTEXT: PL/pgSQL function "cleanupevent" line 100 at assignment</div><div>2014-08-14 18:19:02 EDTINFO cleanupThread: 0.057 seconds for cleanupEvent()</div>
</div><div><div>NOTICE: Slony-I: Logswitch to sl_log_2 initiated</div><div>CONTEXT: SQL statement "SELECT "_slony_example".logswitch_start()"</div><div>PL/pgSQL function "cleanupevent" line 102 at PERFORM</div>
<div>2014-08-14 18:29:52 EDTINFO cleanupThread: 0.004 seconds for cleanupEvent()</div></div><div><div>NOTICE: Slony-I: log switch to sl_log_2 still in progress - sl_log_1 not truncated</div><div>CONTEXT: PL/pgSQL function "cleanupevent" line 100 at assignment</div>
<div>2014-08-14 18:41:15 EDTINFO cleanupThread: 0.038 seconds for cleanupEvent()</div></div><div><br></div><div>OS : Ubuntu 12.04 LTS</div><div>PG : 9.1 from ubuntu package</div><div>slony : 2.0.7 from ubuntu package</div>
<div><br></div>-- <br><div dir="ltr"><div>Thanks,</div><div><br></div>Soni Maula Harriz</div>
</div></div>