pgd group show#
概要#
pgd group show コマンドは、 EDB
Postgres分散クラスターでグループレベルの情報を表示するために使用されます。
ユーザーとロール#
bdr_superuser ロールが必要です。 ユーザーロール を参照してください。
構文#
pgd group <GROUP_NAME> show [OPTIONS]
<GROUP_NAME> は、情報を表示するグループの名前です。
オプション#
次の表は、pgd cluster show
コマンドで使用可能なオプションをリストしています。
Long |
Description |
|---|---|
--summary |
グループの概要のみを表示します。 |
--options |
グループのオプションのみを表示します。 |
--nodes |
グループのノードのみを表示します。 |
一度に指定できるのは、上記のオプションのうちの1つだけです。
Global Options を参照してください。
例#
グループ情報を表示する#
pgd group group-a show
__OUTPUT__
# Summary
Group Property | Value
- ------------------+---------
Group Name | group-a
Parent Group Name | pgdx6
Group Type | data
Write Leader | pgd-a3
Commit Scope |
# Nodes
Node Name | Node Kind | Join State | Node Status
- ----------+-----------+------------+-------------
pgd-a2 | data | ACTIVE | Up
pgd-a3 | data | ACTIVE | Up
pgd-a1 | data | ACTIVE | Up
# Options
Option Name | Option Value | Option Source
- ----------------------------------+---------------+---------------
analytics_autoadd_tables | false | group
analytics_storage_location | | default
apply_delay | 00:00:00 | inherited
check_constraints | true | inherited
default_commit_scope | local protect | group
enable_raft | true | group
enable_routing | true | group
enable_wal_decoder | false | inherited
http_port | 6434 | pg_config
location | London | group
num_writers | 2 | pg_config
read_only_consensus_timeout | 00:00:00 | pg_config
read_only_max_client_connections | 250 | pg_config
read_only_max_server_connections | 250 | pg_config
read_only_port | 6433 | pg_config
read_write_consensus_timeout | 00:00:00 | pg_config
read_write_max_client_connections | 250 | pg_config
read_write_max_server_connections | 250 | pg_config
read_write_port | 6432 | pg_config
route_reader_max_lag | -1 | default
route_writer_max_lag | -1 | default
route_writer_wait_flush | false | group
streaming_mode | null | group
use_https | true | group
グループの概要情報を表示する#
pgd group group-a show --summary
__OUTPUT__
Group Property | Value
- ------------------+---------
Group Name | group-a
Parent Group Name | pgdx6
Group Type | data
Write Leader | pgd-a3
Commit Scope |
グループノード情報の表示#
pgd group group-a show --nodes
__OUTPUT__
Node Name | Node Kind | Join State | Node Status
- ----------+-----------+------------+-------------
pgd-a1 | data | ACTIVE | Up
pgd-a2 | data | ACTIVE | Up
pgd-a3 | data | ACTIVE | Up
グループオプション情報を表示する#
pgd group group-a show --options
__OUTPUT__
Option Name | Option Value | Option Source
- ----------------------------------+---------------+---------------
analytics_autoadd_tables | false | group
analytics_storage_location | | default
apply_delay | 00:00:00 | inherited
check_constraints | true | inherited
default_commit_scope | local protect | group
enable_raft | true | group
enable_routing | true | group
enable_wal_decoder | false | inherited
http_port | 6434 | pg_config
location | London | group
num_writers | 2 | pg_config
read_only_consensus_timeout | 00:00:00 | pg_config
read_only_max_client_connections | 250 | pg_config
read_only_max_server_connections | 250 | pg_config
read_only_port | 6433 | pg_config
read_write_consensus_timeout | 00:00:00 | pg_config
read_write_max_client_connections | 250 | pg_config
read_write_max_server_connections | 250 | pg_config
read_write_port | 6432 | pg_config
route_reader_max_lag | -1 | default
route_writer_max_lag | -1 | default
route_writer_wait_flush | false | group
streaming_mode | null | group
use_https | true | group
グループ情報をJSONとして表示する#
pgd group group-a show -o json
__OUTPUT__
[
{
"Summary": [
{
"info": "Group Name",
"value": "group-a"
},
{
"info": "Parent Group Name",
"value": "pgdx6"
},
{
"info": "Group Type",
"value": "data"
},
{
"info": "Write Leader",
"value": "pgd-a3"
},
{
"info": "Commit Scope",
"value": ""
}
]
},
{
"Nodes": [
{
"join_state": "ACTIVE",
"node_kind_name": "data",
"node_name": "pgd-a2",
"node_status": "Up"
},
{
"join_state": "ACTIVE",
"node_kind_name": "data",
"node_name": "pgd-a3",
"node_status": "Up"
},
{
"join_state": "ACTIVE",
"node_kind_name": "data",
"node_name": "pgd-a1",
"node_status": "Up"
}
]
},
{
"Options": [
{
"option_name": "analytics_autoadd_tables",
"option_source": "group",
"option_value": "false"
},
{
"option_name": "analytics_storage_location",
"option_source": "default",
"option_value": ""
},
{
"option_name": "apply_delay",
"option_source": "inherited",
"option_value": "00:00:00"
},
{
"option_name": "check_constraints",
"option_source": "inherited",
"option_value": "true"
},
{
"option_name": "default_commit_scope",
"option_source": "group",
"option_value": "local protect"
},
{
"option_name": "enable_raft",
"option_source": "group",
"option_value": "true"
},
{
"option_name": "enable_routing",
"option_source": "group",
"option_value": "true"
},
{
"option_name": "enable_wal_decoder",
"option_source": "inherited",
"option_value": "false"
},
{
"option_name": "http_port",
"option_source": "pg_config",
"option_value": "6434"
},
{
"option_name": "location",
"option_source": "group",
"option_value": "London"
},
{
"option_name": "num_writers",
"option_source": "pg_config",
"option_value": "2"
},
{
"option_name": "read_only_consensus_timeout",
"option_source": "pg_config",
"option_value": "00:00:00"
},
{
"option_name": "read_only_max_client_connections",
"option_source": "pg_config",
"option_value": "250"
},
{
"option_name": "read_only_max_server_connections",
"option_source": "pg_config",
"option_value": "250"
},
{
"option_name": "read_only_port",
"option_source": "pg_config",
"option_value": "6433"
},
{
"option_name": "read_write_consensus_timeout",
"option_source": "pg_config",
"option_value": "00:00:00"
},
{
"option_name": "read_write_max_client_connections",
"option_source": "pg_config",
"option_value": "250"
},
{
"option_name": "read_write_max_server_connections",
"option_source": "pg_config",
"option_value": "250"
},
{
"option_name": "read_write_port",
"option_source": "pg_config",
"option_value": "6432"
},
{
"option_name": "route_reader_max_lag",
"option_source": "default",
"option_value": "-1"
},
{
"option_name": "route_writer_max_lag",
"option_source": "default",
"option_value": "-1"
},
{
"option_name": "route_writer_wait_flush",
"option_source": "group",
"option_value": "false"
},
{
"option_name": "streaming_mode",
"option_source": "group",
"option_value": "null"
},
{
"option_name": "use_https",
"option_source": "group",
"option_value": "true"
}
]
}
]