pgd group set-option v5.7.0
Warning: You are not reading the most recent version of this documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
Synopsis
The pgd group set-option command is used to set group-level options in the EDB Postgres Distributed cluster.
Syntax
pgd group <GROUP_NAME> set-option [OPTIONS] <OPTION> <VALUE>
Where <GROUP_NAME> is the name of the group for which you want to get options.
And <OPTION> is the name of a specific group option you want to get and <VALUE> is the value you want it set to.
The following options are available:
Group Options
| Option | Description |
|---|---|
| apply_delay | The delay in applying changes to the group. |
| check_constraints | Whether to check constraints in the group. |
| default_commit_scope | The default commit scope of the group. |
| enable_proxy_routing | Whether to enable proxy routing in the group. |
| enable_raft | Whether to enable Raft in the group. |
| enable_wal_decoder | Whether to enable the WAL decoder in the group. |
| location | The location of the group. |
| num_writers | The number of writers in the group. |
| route_reader_max_lag | The maximum lag for the reader in the group. |
| route_writer_max_lag | The maximum lag for the writer in the group. |
| streaming_mode | The streaming mode of the group. |
| route_writer_wait_flush | The wait time for flushing the writer in the group. |
| default_seqkind | The default sequence kind of the group. |
| default_replica_identity | The default replica identity of the group. |
| conflict_detection_method | The conflict detection method of the group. |
| replay_progress_frequency | The replay progress frequency of the group. |
| batch_inserts | Whether to enable batch inserts in the group. |
| analytics_storage_location | The storage location for analytics in the group. |
| analytics_autoadd_tables | Whether to automatically add tables to analytics in the group. |
Group Proxy Options
| Option | Description |
|---|---|
| proxy_listen_address | The listen address for the proxy in the group. |
| proxy_listen_addresses | The listen addresses for the proxy in the group. |
| proxy_listen_port | The listen port for the proxy in the group. |
| proxy_max_client_conn | The maximum number of client connections for the proxy in the group. |
| proxy_max_server_conn | The maximum number of server connections for the proxy in the group. |
| proxy_server_conn_timeout | The server connection timeout for the proxy in the group. |
| proxy_server_conn_keepalive | The server connection keepalive for the proxy in the group. |
| proxy_fallback_node_groups | The fallback node groups for the proxy in the group. |
| proxy_fallback_node_group_timeout | The fallback node group timeout for the proxy in the group. |
| proxy_consensus_grace_period | The consensus grace period for the proxy in the group. |
| proxy_read_listen_address | The listen address for the read proxy in the group. |
| proxy_read_listen_addresses | The listen addresses for the read proxy in the group. |
| proxy_read_listen_port | The listen port for the read proxy in the group. |
| proxy_read_max_client_conn | The maximum number of client connections for the read proxy in the group. |
| proxy_read_max_server_conn | The maximum number of server connections for the read proxy in the group. |
| proxy_read_server_conn_keepalive | The server connection keepalive for the read proxy in the group. |
| proxy_read_server_conn_timeout | The server connection timeout for the read proxy in the group. |
| proxy_read_consensus_grace_period | The consensus grace period for the read proxy in the group. |
Options
No command specific options. See Global Options.
Examples
Set the location of a group
pgd group dc1_subgroup set-option location London
Output
Command executed successfully
Setting an option to a value with a space in it
pgd group dc1_subgroup set-option location "New York"Output
Command executed successfully