Greetings, I put in a question to slony_general_requests and got this back almost immediately. Does this mean I'm in the queue or have I been bounced out? Thx, Mark
---------- Forwarded message ---------- From: <slony1-general-boun...@lists.slony.info> Date: Thu, Feb 19, 2015 at 9:12 AM Subject: The results of your email commands To: mark.ste...@drivedominion.com The results of your email command are provided below. Attached is your original message. - Results: Ignoring non-text/plain MIME parts - Unprocessed: We are running the following on both master and slave: (a simple 1 master to 1 slave configuration) postgresql 9.2.5 slony1-2.2.2 x86_64 GNU/Linux We currently run altperl scripts to kill / start slon daemons from the slave: cd ...bin folder ./slon_kill -c .../slon_tools.....conf and ./slon_start -c ../slon_tools...conf 1 (and 2) 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 there a prescribed way to accomplish this? I could continue to run them on the slave and send a flag to the master when complete but I'd like to take a simpler approach if possible. Any insight appreciated. Thank you. - Ignored: -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg> - Done. ---------- Forwarded message ---------- From: Mark Steben <mark.ste...@drivedominion.com> To: slony1-general-requ...@lists.slony.info Cc: Date: Thu, 19 Feb 2015 09:15:06 -0500 Subject: slon_kill, slon_start to run on master Good morning, We are running the following on both master and slave: (a simple 1 master to 1 slave configuration) postgresql 9.2.5 slony1-2.2.2 x86_64 GNU/Linux We currently run altperl scripts to kill / start slon daemons from the slave: cd ...bin folder ./slon_kill -c .../slon_tools.....conf and ./slon_start -c ../slon_tools...conf 1 (and 2) 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 there a prescribed way to accomplish this? I could continue to run them on the slave and send a flag to the master when complete but I'd like to take a simpler approach if possible. Any insight appreciated. Thank you. -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg> -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com <http://www.autorevenue.com/> <http://autobasedigital.net/marketing/DD12_sig.jpg>
_______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general