Thu Feb 19 08:38:50 PST 2015
- Previous message: [Slony1-general] sl_log_1 not truncated, could not lock
- Next message: [Slony1-general] Wish to run altperl scripts on master rather than slave
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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-bounces at lists.slony.info> Date: Thu, Feb 19, 2015 at 9:12 AM Subject: The results of your email commands To: mark.steben at 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.steben at drivedominion.com> To: slony1-general-request at 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> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20150219/3d97b7dc/attachment.htm
- Previous message: [Slony1-general] sl_log_1 not truncated, could not lock
- Next message: [Slony1-general] Wish to run altperl scripts on master rather than slave
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list