NAME

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

SYNOPSIS

       MOVE SET (options);

DESCRIPTION

       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 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(p_new_origin integer, p_set_id integer)” [not available as a
       man page].

EXAMPLE

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

LOCKING BEHAVIOUR

       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.

SLONIK EVENT CONFIRMATION BEHAVIOUR

       Slonik waits for the command submitted to the previous event node to be confirmed  on  the
       specified event node before submitting this command.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0

                                         1 November 2021                       SLONIK MOVE SET(7)