Mark Steben mark.steben at drivedominion.com
Thu Feb 19 08:38:50 PST 2015
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 


More information about the Slony1-general mailing list