Man Linux: Main Page and Category List


       INIT CLUSTER - Initialize Slony-I cluster


       INIT CLUSTER [ID = integer] [COMMENT = string]


       Initialize  the  first  node  in a new Slony-I replication cluster. The
       initialization process consists  of  creating  the  cluster  namespace,
       loading all the base tables, functions, procedures and initializing the
       node,  using  “schemadocinitializelocalnode(  integer,  text  )”   [not
       available  as  a  man  page]  and “schemadocenablenode( integer )” [not
       available as a man page].

       ID     The unique, numeric ID number of the node.

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

       For this process to work, the SQL scripts of the Slony-I system must be
       installed on the DBA workstation (the computer currently executing  the
       slonik utility), while on the system where the node database is running
       the shared objects of the Slony-I  system  must  be  installed  in  the
       PostgreSQL  library directory. Also the procedural language PL/pgSQL is
       assumed to already be installed in the target database.


          ID = 1,
          COMMENT = ’Node 1’


              This command functions very similarly to SLONIK  STORE  NODE(7),
              the  difference  being  that  INIT CLUSTER does not need to draw
              configuration from other existing nodes.

              Be aware that some objects are created that contain the  cluster
              name  as  part  of  their  name.  (Notably,  partial  indexes on
              sl_log_1 and sl_log_2.) As a result, really long  cluster  names
              are a bad idea, as they can make object names ‘blow up’ past the
              typical maximum name length of 63 characters.


       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

                                  12 May 2010           SLONIK INIT CLUSTER(7)