Provided by: slony1-doc_1.2.13-1_all bug


       STORE NODE - Initialize Slony-I node


       STORE NODE (options);


       Initialize  a  new  node and add it to the configuration of an existing

       The initialization process consists of creating the  cluster  namespace
       in  the  new node (the database itself must already exist), loading all
       the base tables, functions, procedures and initializing the  node.  The
       existing  configuration  of  the rest of the cluster is copied from the
       ‘event node’.

       ID = ival
              The unique, numeric ID number of the new node.

       COMMENT = ’description’
              A descriptive  text  added  to  the  node  entry  in  the  table
              “sl_node” [not available as a man page]

       SPOOLNODE = boolean
              Specifies  that  the  new  node is a virtual spool node for file
              archiving of replication log. If true, slonik will  not  attempt
              to initialize a database with the replication schema.

       EVENT NODE = ival
              The  ID  of the node used to create the configuration event that
              tells all existing nodes about the new node. Default value is 1.

       This   uses   “schemadocinitializelocalnode(   integer,  text  )”  [not
       available as a man page]  and  “schemadocenablenode(  integer  )”  [not
       available as a man page].


            STORE NODE ( ID = 2, COMMENT = ’Node 2’);


       This  command creates a new namespace and configures tables therein; no
       public objects should be locked during the duration of this.


       This command was introduced in Slony-I 1.0. The SPOOLNODE parameter was
       introduced  in  version  1.1,  but  was  vestigal  in that version. The
       described functionality for SPOOLNODE arrives in version 1.2.

                                 28 March 2008                   STORE NODE(7)