<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Jan,</span></div><div><br><span></span></div><div><span><br></span></div><div><span>I would like to say that I appreciate your reply, your help and your diagnostic. It is very helpful.<br></span></div><div><span><br></span></div><div><span> I may understand your opinion and you're right to say that you don't have enough information (...). <br></span></div><div><br></div><div>Upgrading Slony version is a solution. (1.2 is very old!) I agree<br><span></span></div><div><br><span></span></div><div><span>Thanks.<br></span></div><div><br><span></span></div><br><span></span><div><span><br></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial"
size="2"> <hr size="1"> <b><span style="font-weight:bold;">De :</span></b> Jan Wieck <JanWieck@Yahoo.com><br> <b><span style="font-weight: bold;">À :</span></b> David TECHER <davidtecher@yahoo.fr> <br><b><span style="font-weight: bold;">Cc :</span></b> Slony Hackers <slony1-hackers@lists.slony.info> <br> <b><span style="font-weight: bold;">Envoyé le :</span></b> Vendredi 27 juillet 2012 0h50<br> <b><span style="font-weight: bold;">Objet :</span></b> Re: [Slony1-hackers] sl_log_1 doesn't stop to grow<br> </font> </div> <br>On 7/26/2012 10:09 AM, David TECHER wrote:<br>> Hi Jan,<br>><br>> Thanks for sharing these information.<br>><br>> Do you think it is worth waiting that replication could catch up properly.<br><br>I don't have enough information to say if it is worth or not.<br><br>><br>> Yesterday while this issue was occuring<br>><br>> - I stopped replication on all nodes and<br>>
- I restarted the PostgreSQL server on the master<br>> - I restaerted Slony processes on all nodes.<br>><br>> Then I guess that my issue is related to "A replica that is far behind."<br><br>Why do you guess instead of properly analyzing the problem?<br><br>Can you please run the query "select * from _<clustername>.sl_status;" <br>twice on the master, waiting 5 minutes in between the runs and post the <br>result here?<br><br>><br>> Indeed Slony processes are redirected localy on the disk (/ partition)<br>> with log_level = 1. I don't used any log rotate mechanism<br><br>If the redirected Slony output is eating your space on the root <br>partition, then using something like the Apache's rotatelogs or syslog <br>would be a good way to fix that.<br><br>><br>> There is free disk space (50GB) if need on /var/database partition or do<br>> you advise me to stop replication and rebuidl replication for scratch??<br><br>No, I
suggest to figure out what the actual problem is. Do you knock <br>down the house and build a new one if you find you cannot open the front <br>door? Or do you call the locksmith to fix it?<br><br>I would also suggest to plan upgrading to a newer version of Slony.<br><br><br>Jan<br><br>-- <br>Anyone who trades liberty for security deserves neither<br>liberty nor security. -- Benjamin Franklin<br><br><br> </div> </div> </div></body></html>