NAME

       RESUBSCRIBE NODE - Change the provider of a replication set

SYNOPSIS

       RESUBSCRIBE NODE (options);

DESCRIPTION

       The RESUBSCRIBE NODE command will change the provider used to receive data from for all of
       the replication sets originating on a given node.  If a subscriber  node  is  receiving  a
       number  of  replication sets with a particular node as an origin then the RESUBSCRIBE NODE
       command will change the provider node  used  by  that  subscriber  node  for  all  of  the
       replication sets originating on the given origin.

       ORIGIN = ival
              ID of the set origin for all subscriptions to change

       RECEIVER = ival
              Node ID of the subscriber

       PROVIDER = ival
              Node ID of the provider

EXAMPLE

       RESUBSCRIBE NODE  (
          ORIGIN = 1,
          PROVIDER = 2,
          RECEIVER = 3
       );

LOCKING BEHAVIOUR

       None

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 2.2

                                         1 November 2021               SLONIK RESUBSCRIBE NODE(7)