<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div><div>Good morning,<br><br></div>We are running the following on both master and slave: (a simple 1 master to 1 slave configuration)<br></div> postgresql 9.2.5<br></div> slony1-2.2.2<br> x86_64 GNU/Linux<br><br></div>We currently run altperl scripts to kill / start slon daemons from the slave:<br></div> cd ...bin folder<br></div> ./slon_kill -c .../slon_tools.....conf <br></div> and<br></div> ./slon_start -c ../slon_tools...conf 1 (and 2)<br><br></div> Because
we need to run maintenance on the replicated db on the master without
slony running I would like to run these commands on the master before
and after the maintenance. Since the daemons now run on the slave when I
attempt to run these commands on the master the daemons aren't found.
Is<br></div>there a prescribed way to accomplish this? I could continue to run them on the<br></div>slave and send a flag to the master when complete but I'd like to take a simpler approach if possible. <br></div> Any insight appreciated. Thank you.<br><br clear="all"><br clear="all"><br>-- <br><div class="gmail_signature"><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br><a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br> <span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br><a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br><br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br></span></span></font></span></p><font color="#888888"></font></div>
</div>