Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SLONIK SET MOVE	TABLE(7Configuration and Action	commanSLONIK SET MOVE TABLE(7)

NAME
       SET  MOVE  TABLE	 - Move	a table	from one    Slony-I replication	set to
       another

SYNOPSIS
       SET MOVE	TABLE (options);

DESCRIPTION
       Change the set a	table belongs to. The current set and the new set must
       origin on the same node and subscribed by the same nodes.

	      Caution: Due to the way subscribing to new sets works make abso-
	      lutely sure that the subscription	of all nodes to	 the  sets  is
	      completely  processed  before  moving tables. Moving a table too
	      early to a new set causes	the subscriber to try and add the  ta-
	      ble  already during the subscription process, which fails	with a
	      duplicate	key error and breaks replication.

	ORIGIN = ival
	      Current origin of	the set.  A future  version  of	 slonik	 might
	      figure out this information by itself.

	ID = ival
	      Unique ID	of the table.

	NEW SET	= ival
	      Unique ID	of the set to which the	table should be	added.

       This uses setmovetable(integer,integer).

EXAMPLE
       SET MOVE	TABLE (
	   ORIGIN = 1,
	   ID =	20,
	   NEW SET = 3
       );

LOCKING	BEHAVIOUR
       No application-visible locking should take place.

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.5

				  30 May 2016	      SLONIK SET MOVE TABLE(7)

NAME | SYNOPSIS | DESCRIPTION | EXAMPLE | LOCKING BEHAVIOUR | SLONIK EVENT CONFIRMATION BEHAVIOUR | VERSION INFORMATION

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=SLONIK_SET_MOVE_TABLE&sektion=7&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help