Rechercher une page de manuel
SET_MOVE_SEQUENCE
Langue: en
Version: 17 November 2008 (ubuntu - 08/07/09)
Section: 7 (Divers)
NAME
SET MOVE SEQUENCE - Move a sequence from one Slony-I replication set to anotherSYNOPSIS
SET MOVE SEQUENCE (options);DESCRIPTION
Change the set a sequence belongs to. The current set and the new set must originate on the same node and subscribed by the same nodes.- Caution
Due to the way subscribing to new sets works make absolutely sure that the subscription of all nodes to the sets is completely processed before moving sequences. Moving a sequence too early to a new set causes the subscriber to try and add the sequence already during the subscription process, which fails with a duplicate key error and breaks replication.
- ORIGIN = ival
- Origin node for the set. A future version of slonik might figure out this information by itself.
- ID = ival
- Unique ID of the sequence.
- NEW SET = ival
- Unique ID of the set to which the sequence should be moved.
This uses "schemadocsetmovesequence( integer, integer )" [not available as a man page].
EXAMPLE
SET MOVE SEQUENCE ( ORIGIN = 1, ID = 20, NEW SET = 3 );
LOCKING BEHAVIOUR
No application-visible locking should take place.VERSION INFORMATION
This command was introduced in Slony-I 1.0.5Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre