Soni M diptatapa at gmail.com
Thu Aug 14 16:55:52 PDT 2014
Hello Everyone,

I thought i got those cleanup event every 10 minutes, which is the default.
I desired another value for this parameter, but seems didn't work. I set
them to 20 minutes.
How can i change the value for cleanup event on slon process?

config :
cleanup_interval="20 minutes"

related log :
NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
CONTEXT:  PL/pgSQL function "cleanupevent" line 100 at assignment
2014-08-14 17:46:23 EDTINFO   cleanupThread:    0.060 seconds for
cleanupEvent()
NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
CONTEXT:  SQL statement "SELECT "_slony_example".logswitch_start()"
PL/pgSQL function "cleanupevent" line 102 at PERFORM
2014-08-14 17:57:18 EDTINFO   cleanupThread:    0.005 seconds for
cleanupEvent()
NOTICE:  Slony-I: log switch to sl_log_1 still in progress - sl_log_2 not
truncated
CONTEXT:  PL/pgSQL function "cleanupevent" line 100 at assignment
2014-08-14 18:08:13 EDTINFO   cleanupThread:    0.043 seconds for
cleanupEvent()
NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
CONTEXT:  PL/pgSQL function "cleanupevent" line 100 at assignment
2014-08-14 18:19:02 EDTINFO   cleanupThread:    0.057 seconds for
cleanupEvent()
NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
CONTEXT:  SQL statement "SELECT "_slony_example".logswitch_start()"
PL/pgSQL function "cleanupevent" line 102 at PERFORM
2014-08-14 18:29:52 EDTINFO   cleanupThread:    0.004 seconds for
cleanupEvent()
NOTICE:  Slony-I: log switch to sl_log_2 still in progress - sl_log_1 not
truncated
CONTEXT:  PL/pgSQL function "cleanupevent" line 100 at assignment
2014-08-14 18:41:15 EDTINFO   cleanupThread:    0.038 seconds for
cleanupEvent()

OS : Ubuntu 12.04 LTS
PG : 9.1 from ubuntu package
slony : 2.0.7 from ubuntu package

-- 
Thanks,

Soni Maula Harriz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20140815/1be214b5/attachment.htm 


More information about the Slony1-general mailing list