Man Linux: Main Page and Category List

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 absolutely
              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
              table  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 “schemadocsetmovetable( integer, integer )” [not available as
       a man page].

EXAMPLE

       SET MOVE TABLE (
           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.5

                                  12 May 2010         SLONIK SET MOVE TABLE(7)