verify-settings#
EDB Postgres Distributedクラスター設定を確認します。
概要#
EDB Postgres Distributedクラスター設定を確認します。
pgd verify-settings [flags]
オプション#
特定のコマンドオプションはありません。グローバルオプションについては、 グローバルオプション を参照してください。
例#
クラスター設定の検証#
$ pgd verify-settings
__OUTPUT__
# bdr.accept_connections
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Critical false off must be set to on
bdr-a2 Ok false on
bdr-b1 Ok false on
bdr-b2 Ok false on
logical-standby-a1 Ok false on
logical-standby-b1 Ok false on
subscriber-only-c1 Ok false on
witness-a Ok false on
witness-b Ok false on
witness-c Ok false on
Warning: value must be same on all primary nodes
# bdr.ddl_locking
Ok: all node values are ok
# bdr.ddl_replication
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false 0 must be set to on
bdr-a2 Ok false on
bdr-b1 Ok false on
bdr-b2 Ok false on
logical-standby-a1 Ok false on
logical-standby-b1 Ok false on
subscriber-only-c1 Ok false on
witness-a Ok false on
witness-b Ok false on
witness-c Ok false on
Warning: value must be same on all primary nodes
# bdr.max_writers_per_subscription
Ok: all node values are ok
# bdr.raft_group_max_connections
Ok: all node values are ok
# bdr.replay_progress_frequency
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false 61000 must be <= 60000
bdr-a2 Ok false 60000
bdr-b1 Ok false 60000
bdr-b2 Ok false 60000
logical-standby-a1 Ok false 60000
logical-standby-b1 Ok false 60000
subscriber-only-c1 Ok false 60000
witness-a Ok false 60000
witness-b Ok false 60000
witness-c Ok false 60000
Warning: value must be same on all primary nodes
# bdr.role_replication
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false off must be set to on
bdr-a2 Ok false on
bdr-b1 Ok false on
bdr-b2 Ok false on
logical-standby-a1 Ok false on
logical-standby-b1 Ok false on
subscriber-only-c1 Ok false on
witness-a Ok false on
witness-b Ok false on
witness-c Ok false on
Warning: value must be same on all primary nodes
# bdr.standby_slot_names
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false bdr_bdrdb_ja… must contain valid logical slots of peer data nodes only
bdr-a2 Warning false bdr_bdrdb_ja… must contain valid logical slots of peer data nodes only
bdr-b1 Warning false must contain valid logical slots of peer data nodes only
bdr-b2 Warning false must contain valid logical slots of peer data nodes only
logical-standby-a1 Ok false
logical-standby-b1 Ok false
subscriber-only-c1 Ok false
witness-a Ok false
witness-b Ok false
witness-c Ok false
# bdr.standby_slots_min_confirmed
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false -1 must be >= 1
bdr-a2 Warning false -1 must be >= 1
bdr-b1 Warning false -1 must be >= 1
bdr-b2 Warning false -1 must be >= 1
logical-standby-a1 Ok false -1
logical-standby-b1 Ok false -1
subscriber-only-c1 Ok false -1
witness-a Ok false -1
witness-b Ok false -1
witness-c Ok false -1
# bdr.start_workers
Ok: all node values are ok
# bdr.xact_replication
Ok: all node values are ok
# max_prepared_transactions
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false 16 must be >= 250
bdr-a2 Warning false 16 must be >= 250
bdr-b1 Warning false 16 must be >= 250
bdr-b2 Warning false 16 must be >= 250
logical-standby-a1 Warning false 16 must be >= 250
logical-standby-b1 Warning false 16 must be >= 250
subscriber-only-c1 Warning false 16 must be >= 250
witness-a Warning false 16 must be >= 250
witness-b Warning false 16 must be >= 250
witness-c Warning false 16 must be >= 250
# max_replication_slots
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Critical false 8 must be >= 10
bdr-a2 Ok false 12
bdr-b1 Ok false 12
bdr-b2 Ok false 12
logical-standby-a1 Ok false 12
logical-standby-b1 Ok false 12
subscriber-only-c1 Ok false 12
witness-a Ok false 12
witness-b Ok false 12
witness-c Ok false 12
Warning: value must be same on all primary nodes
# max_wal_senders
Ok: all node values are ok
# max_worker_processes
Ok: all node values are ok
# shared_preload_libraries
Node Status Pending Restart Value Message
- --- ------ --------------- ----- -------
bdr-a1 Warning false pg_stat_stat… must contain bdr as first entry
bdr-a2 Warning false pg_stat_stat… must contain bdr as first entry
bdr-b1 Warning false pg_stat_stat… must contain bdr as first entry
bdr-b2 Warning false pg_stat_stat… must contain bdr as first entry
logical-standby-a1 Warning false pg_stat_stat… must contain bdr as first entry
logical-standby-b1 Warning false pg_stat_stat… must contain bdr as first entry
subscriber-only-c1 Warning false pg_stat_stat… must contain bdr as first entry
witness-a Warning false pg_stat_stat… must contain bdr as first entry
witness-b Warning false pg_stat_stat… must contain bdr as first entry
witness-c Warning false pg_stat_stat… must contain bdr as first entry
# track_commit_timestamp
Ok: all node values are ok
# wal_level
Ok: all node values are ok