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.
This command was introduced in Slony-I 2.2