INIT CLUSTER - Initialize Slony-I 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(p_comment integer, p_local_node_id
text)” [not available as a man page] and
“schemadocenablenode(p_no_id integer)” [not available as a man
- 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.
INIT CLUSTER (
ID = 1,
COMMENT = 'Node 1'
This command functions very similarly to SLONIK STORE NODE
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
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
This command creates a new namespace and configures tables therein; no public
objects should be locked during the duration of this.
Slonik does not wait for event confirmations before performing this command.
This command was introduced in Slony-I 1.0