pgd commit-scope create v5.7.0

Synopsis

The pgd commit-scope create command is used to create a commit scope in the EDB Postgres Distributed cluster.

Syntax

pgd commit-scope <COMMIT_SCOPE> create [OPTIONS] <RULE_DEFINITION> [GROUP_NAME]

Where <COMMIT_SCOPE> is the name of the commit scope to create.

The <RULE_DEFINITION> is the rule that defines the commit scope. The rule specifies the conditions that must be met for a transaction to be considered committed. See Commit Scopes and Commit Scope Rules for more information on the rule syntax.

The optional [GROUP_NAME] is the name of the group to which the commit scope belongs. If omitted, it defaults to the top-level group.

Options

No command specific options. See Global Options.

Examples

Creating a Commit Scope

The following example creates a commit scope named abc1 with the rule ANY 2 (dc1) on replicated group commit on the dc1_subgroup group:

pgd commit-scope abc1 create "ANY 2 (dc1_subgroup) SYNCHRONOUS COMMIT" dc1_subgroup

Command executed successfully

Verify the commit scope:

pgd commit-scope abc1 show

Commit Scope Group Name   Rule Definition
------------ ------------ ---------------------------------------
abc1         dc1_subgroup ANY 2 (dc1_subgroup) SYNCHRONOUS COMMIT

Creating a Commit Scope with the top-level group

The following example creates a commit scope named abc2 with the rule ANY 2 (dc1_subgroup) SYNCHRONOUS COMMIT on the top-level group:

pgd commit-scope abc2 create "ANY 2 (dc1_subgroup) SYNCHRONOUS COMMIT"

Command executed successfully

Verify the commit scope:

pgd commit-scope abc2 show

Commit Scope Group Name  Rule Definition
------------ ----------- ---------------------------------------
abc2         democluster ANY 2 (dc1_subgroup) SYNCHRONOUS COMMIT