<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><font size="3">Kevin,<br><br>I installed Slony from source. I rarely use RPM, so this is not the cause.<br>Slony 2.0.2 already contains a fix for a bug I found (ERROR in analyze on slony schema in cleanup thread)</font><font size="3">, and since the clean_interval parameter is new to Slony 2, it's highly likely this is another one. <br><br></font><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br> <font size="3"></font><font size="3"><span style="font-weight: bold; font-family: courier;">Folk Alley - All Folk - 24 Hours a day </span><span style="font-weight: bold; font-family: courier;"><br>www.folkalley.com<br><br></span></font></div><br><br>--- On <b>Tue, 5/26/09, Kevin Kempter <i><kevink@consistentstate.com></i></b> wrote:<br><blockquote style="border-left:
2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Kevin Kempter <kevink@consistentstate.com><br>Subject: Re: [Slony1-general] cleanup_interval parameter not working<br>To: slony1-general@lists.slony.info<br>Date: Tuesday, May 26, 2009, 9:23 AM<br><br><div id="yiv840926116"><style type="text/css">#yiv840926116 p, #yiv840926116 li {white-space:pre-wrap;}</style><p style="margin: 0px; text-indent: 0px;"><br></p><p style="margin: 0px; text-indent: 0px;"><br></p>> CentOS-5.3<br>
> PostgreSQL 8.3.7<br>
> Slony 2.0.2<br>
><br>
> It appears that the cleanup_interval parameter is not being read from the<br>
> slon.conf.<br>
><br>
> It is my understanding that if a parameter is not specified in the slon<br>
> command line, it takes it from the slon.conf.<br>
><br>
> In my slon.conf I have:<br>
> =======================================================<br>
><br>
> Title = "slon"<br>
><br>
> # Which logfile group...<br>
> Logfile = /var/lib/pgsql/slony/slon.log<br>
> cleanup_interval="60 minutes"<br>
><br>
> # Only give lines pertaining to the sshd service...<br>
> *OnlyService = slon<br>
> *RemoveHeaders<br>
><br>
> =======================================================<br>
><br>
> My startup command is:<br>
><br>
> source $HOME/.bash_profile<br>
> slon -d1 -c0 -pslon_mas_1.pid $MAS_CLUSTER "dbname=$REPDB<br>
> user=$REPLICATIONUSER host=$MASTERHOST port=$PGPORT" > slon.log &<br>
><br>
><br>
> Yet, when I check the slon.log, I see<br>
><br>
> 2009-05-26 09:32:41 EDT CONFIG main: String option cleanup_interval = 10<br>
> minutes<br>
><br>
><br>
> So either the cleanup_interval parameter is not being accepted, or I have<br>
> misread the documentation. Also, the documentation does not specify the<br>
> intervals accepted. Ideally, I would like to set this to "24 hours" or "1<br>
> day" but I am not sure if that is permissible.<br>
><br>
> Melvin Davidson<br>
> Folk Alley - All Folk - 24 Hours a day<br>
> www.folkalley.com<br>
<p style="margin: 0px; text-indent: 0px;"><br></p><p style="margin: 0px; text-indent: 0px;"><br></p>Hi Melvin;<br>
<p style="margin: 0px; text-indent: 0px;"><br></p>Did you install SLONY via RPM ? I've seen similar issues with RPM's on CentOS/Red Hat that were resolved once we installed SLONY via the source.<br>
<p style="margin: 0px; text-indent: 0px;"><br></p><p style="margin: 0px; text-indent: 0px;"><br></p><p style="margin: 0px; text-indent: 0px;"><br></p>/Kevin<br>
<p style="margin: 0px; text-indent: 0px;"><br></p></div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="/mc/compose?to=Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br></div></blockquote></td></tr></table><br>