Man Linux: Main Page and Category List


       MOVE SET - Change origin of a Slony-I replication set


       MOVE SET (options);


       Changes  the  origin  of a set from one node to another. The new origin
       must be a current subscriber of the set.  The  set  must  currently  be
       locked on the old origin.

       After  this  command,  the set cannot be unlocked on the old origin any
       more. The old origin will continue as a forwarding  subscriber  of  the
       set  and  the  subscription chain from the old origin to the new origin
       will be reversed, hop by hop. As soon as the new  origin  has  finished
       processing  the  event  (that includes any outstanding sync events that
       happened before, i.e. fully catching up), the new origin will take over
       and  open all tables in the set for client application update activity.

       This is not failover, as it requires a functioning old origin node (you
       needed to lock the set on the old origin). You would probably prefer to
       MOVE SET instead of FAILOVER, if at all possible, as FAILOVER winds  up
       discarding the old origin node as being corrupted. Before MOVE SET will
       function a LOCK SET is needed.

       Note that this is a locking [“Locking Issues” [not available as  a  man
       page]]  operation,  which  means  that  it  can  get stuck behind other
       database activity.

       ID = ival
              ID of the set to transfer

       OLD ORIGIN = ival
              Node ID of the current set origin

       NEW ORIGIN = ival
              Node ID of the new set origin

       This uses “schemadocmoveset( integer, integer )” [not  available  as  a
       man page].


       LOCK SET (
          ID = 1,
          ORIGIN = 1
       MOVE SET (
          ID = 1,
          OLD ORIGIN = 1,
          NEW ORIGIN = 3


       Exclusive  locks on each replicated table will be taken out on both the
       old origin node and the new origin node, as  replication  triggers  are
       changed  on  both  nodes:  on  the  former  origin,  each table has two
       triggers (logtrigger and lockset)  dropped  and  a  denyaccess  trigger
       added;  on  the  new  origin,  the  denyaccess trigger is dropped and a
       logtrigger trigger added.


       This command was introduced in Slony-I 1.0

                                  12 May 2010               SLONIK MOVE SET(7)