<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Sans Serif'; font-size:8pt; font-weight:400; font-style:normal;"><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><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="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Hi Melvin;<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><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="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>/Kevin<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p></body></html>