|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|
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.
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 1.0
|SLONIK MOVE SET (7)||18 January 2015|