'\" -*- coding: us-ascii -*- .if \n(.g .ds T< \\FC .if \n(.g .ds T> \\F[\n[.fam]] .de URL \\$2 \(la\\$1\(ra\\$3 .. .if \n(.g .mso www.tmac .TH "SLONIK INIT CLUSTER" 7 "24 July 2014" "" "Slony-I 2.2.3 Documentation" .SH NAME INIT CLUSTER \- Initialize Slony-I cluster .SH SYNOPSIS 'nh .fi .ad l \fBINIT CLUSTER\fR \kx .if (\nx>(\n(.l/2)) .nr x (\n(.l/5) 'in \n(.iu+\nxu [ID = \fIinteger\fR] [COMMENT = \fI'string'\fR] 'in \n(.iu-\nxu .ad b 'hy .SH DESCRIPTION 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 \(lqschemadocinitializelocalnode(p_comment integer, p_local_node_id text)\(rq [not available as a man page] and \(lqschemadocenablenode(p_no_id integer)\(rq [not available as a man page]. .TP \*(T The unique, numeric ID number of the node. .TP \*(T A descriptive text added to the node entry in the table \(lqsl_node\(rq [not available as a man page]. .PP 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. .SH EXAMPLE .nf \*(T .fi .RS \fBNote\fR .PP This command functions very similarly to \fBSLONIK STORE NODE\fR(7), the difference being that \fBINIT CLUSTER \fRdoes not need to draw configuration from other existing nodes. .RE .RS \fBNote\fR .PP Be aware that some objects are created that contain the cluster name as part of their name. (Notably, partial indexes on \fBsl_log_1\fR and \fBsl_log_2\fR.) As a result, \fIreally long\fR cluster names are a bad idea, as they can make object names \(oqblow up\(cq past the typical maximum name length of 63 characters. .RE .SH "LOCKING BEHAVIOUR " This command creates a new namespace and configures tables therein; no public objects should be locked during the duration of this. .SH "SLONIK EVENT CONFIRMATION BEHAVIOUR " Slonik does not wait for event confirmations before performing this command. .SH "VERSION INFORMATION " This command was introduced in Slony-I 1.0