Provided by: slony1-doc_1.2.15-1_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 appli‐
        cation, 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 ‘sub‐
        scriber’.
 
        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’ );
        No application-visible locking should take place.
        This command was introduced in Slony-I 1.0
 
        Until version 1.2, it would crash if no comment was provided.
 
                                17 November 2008                  CREATE SET(7)