logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

CLUSTER NAME - preamble - identifying Slony-I cluster

Description

Must be the very first statement in every slonik script. It defines the namespace in which all Slony-I specific functions, procedures, tables and sequences are defined. The namespace name is built by prefix‐ ing the given string literal with an underscore. This namespace will be identical in all databases that participate in the same replication group. No user objects are supposed to live in this namespace, and the namespace is not allowed to exist prior to adding a database to the replication system. Thus, if you add a new node using pg_dump-s on a data‐ base that is already in the cluster of replicated databases, you will need to drop the namespace via the SQL command DROPSCHEMA_testclusterCASCADE; .

Example

CLUSTER NAME = testcluster;

Name

CLUSTER NAME - preamble - identifying Slony-I cluster

Synopsis

CLUSTERNAME= [clustername;]

Version Information

This command was introduced in Slony-I 1.0 19 September 2024 SLONIKCLUSTERNAME(7)

See Also