<div dir="ltr"><div><div>Greetings, I put in a question to slony_general_requests and got this back almost immediately.<br></div>Does this mean I'm in the queue or have I been bounced out?<br></div>Thx, Mark<br><br><div><div><div><div><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername"></b> <span dir="ltr"><<a href="mailto:slony1-general-bounces@lists.slony.info">slony1-general-bounces@lists.slony.info</a>></span><br>Date: Thu, Feb 19, 2015 at 9:12 AM<br>Subject: The results of your email commands<br>To: <a href="mailto:mark.steben@drivedominion.com">mark.steben@drivedominion.com</a><br><br><br>The results of your email command are provided below. Attached is your<br>
original message.<br>
<br>
- Results:<br>
Ignoring non-text/plain MIME parts<br>
<br>
- Unprocessed:<br>
We are running the following on both master and slave: (a simple 1 master<br>
to 1 slave configuration)<br>
postgresql 9.2.5<br>
slony1-2.2.2<br>
x86_64 GNU/Linux<br>
We currently run altperl scripts to kill / start slon daemons from the<br>
slave:<br>
cd ...bin folder<br>
./slon_kill -c .../slon_tools.....conf<br>
and<br>
./slon_start -c ../slon_tools...conf 1 (and 2)<br>
Because we need to run maintenance on the replicated db on the master<br>
without slony running I would like to run these commands on the master<br>
before and after the maintenance. Since the daemons now run on the slave<br>
when I attempt to run these commands on the master the daemons aren't<br>
found. Is<br>
there a prescribed way to accomplish this? I could continue to run them on<br>
the<br>
slave and send a flag to the master when complete but I'd like to take a<br>
simpler approach if possible.<br>
Any insight appreciated. Thank you.<br>
<br>
- Ignored:<br>
<br>
<br>
--<br>
*Mark Steben*<br>
Database Administrator<br>
@utoRevenue <<a href="http://www.autorevenue.com/" target="_blank">http://www.autorevenue.com/</a>> | Autobase<br>
<<a href="http://www.autobase.net/" target="_blank">http://www.autobase.net/</a>><br>
CRM division of Dominion Dealer Solutions<br>
95D Ashley Ave.<br>
West Springfield, MA 01089<br>
t: <a href="tel:413.327-3045" value="+14133273045">413.327-3045</a><br>
f: <a href="tel:413.383-9567" value="+14133839567">413.383-9567</a><br>
<br>
<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>
<a href="http://www.drivedominion.com" target="_blank">www.drivedominion.com</a> <<a href="http://www.autorevenue.com/" target="_blank">http://www.autorevenue.com/</a>><br>
<br>
<<a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank">http://autobasedigital.net/marketing/DD12_sig.jpg</a>><br>
<br>
- Done.<br>
<br>
<br><br>---------- Forwarded message ----------<br>From: Mark Steben <<a href="mailto:mark.steben@drivedominion.com">mark.steben@drivedominion.com</a>><br>To: <a href="mailto:slony1-general-request@lists.slony.info">slony1-general-request@lists.slony.info</a><br>Cc: <br>Date: Thu, 19 Feb 2015 09:15:06 -0500<br>Subject: slon_kill, slon_start to run on master<br><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><div><div><div><div><div><div><div><div><div><br clear="all"><div><div><div><div><br>-- <br><div><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></div></div></div></div></div></div></div></div></div></div></div></div></div>
<br></div><br><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></div></div></div></div>