pgd commit-scope show v5
Synopsis
The pgd commit-scope show
command is used to display information about a commit scope in the EDB Postgres Distributed cluster.
Syntax
pgd commit-scope <COMMIT_SCOPE> show [OPTIONS]
Where <COMMIT_SCOPE>
is the name of the commit scope for which you want to display information.
Options
No command specific options. See Global Options.
Example
Showing a Commit Scope
The following example shows the information about the commit scope abc1
:
pgd commit-scope abc1 show
Output
Commit Scope Group Name Rule Definition ------------ ---------- -------------------------------------- abc1 dc1 ANY 2 (dc1) on replicated group commit
The Rule Definition
column shows the rule that defines the commit scope. In this case, the rule is ANY 2 (dc1) on replicated group commit
. This rule specifies that the commit scope abc1
requires at least two nodes in the dc1
group to commit a transaction before it is considered committed. The dc1
group is a replicated group, so the commit must be replicated to at least two nodes in the group.