Provided by: slony1-2-doc_2.0.7-3build1_all bug

NAME

       CREATE SET - Create Slony-I replication set

SYNOPSIS

       CREATE SET (options);

DESCRIPTION

       In  the  Slony-I replication system, replicated tables are organized in
       sets. As a general rule of thumb, a set should contain all  the  tables
       of  one  application,  that  have  relationships.  In  a  well designed
       application, this is equal to all the tables in one schema.

       The smallest unit one node can subscribe for replication  from  another
       node  is  a  set.  A set always has an origin. In classical replication
       terms, that would be the 'master.' Since in Slony-I a node can  be  the
       'master'  over one set, while receiving replication data in the 'slave'
       role for another at the same time, this terminology may  easily  become
       misleading  and  should  therefore  be  replaced  with 'set origin' and
       'subscriber'.

       ID = ival
              ID of the set to be created.

       ORIGIN = ival
              Initial origin node of the set.

       COMMENT = 'string'
              A descriptive text added to the set entry.

              If none is provided, a default value is set; A  replication  set
              so boring no one thought to give it a name.

       This  uses  "schemadocstoreset(integer,  text)" [not available as a man
       page] .

EXAMPLE

            CREATE SET ( ID = 1,
                      ORIGIN = 1,
                      COMMENT = 'Tables for ticketing system' );

LOCKING BEHAVIOUR

       No application-visible locking should take place.

VERSION INFORMATION

       This command was introduced in Slony-I 1.0

       Until version 1.2, it would crash if no comment was provided.

                                3 December 2011           SLONIK CREATE SET(7)