pgd commit-scope create

pgd commit-scope create#

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
__OUTPUT__
Command executed successfully

Verify the commit scope:

pgd commit-scope abc1 show
__OUTPUT__
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"
__OUTPUT__
Command executed successfully

Verify the commit scope:

pgd commit-scope abc2 show
__OUTPUT__
Commit Scope Group Name  Rule Definition
- ----------- ----------- ---------------------------------------
abc2         democluster ANY 2 (dc1_subgroup) SYNCHRONOUS COMMIT
Contents