verify-settings#
Verifies the EDB Postgres Distributed cluster settings.
Synopsis#
Verifies the EDB Postgres Distributed cluster settings.
pgd verify-settings [flags]
Examples#
Example 1
$ pgd verify-settings
# 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
Options#
-h, --help help for verify-settings
Options inherited from parent commands#
-f, --config-file string config file; ignored if
--dsn flag is present (default "/etc/edb/pgd-cli/pgd-cli-config.yml")
--dsn string database connection string
e.g."host=bdr-a1 port=5432 dbname=bdrdb user=postgres "
-L, --log-level string logging level: debug, info, warn, error (default "error")
-o, --output string output format: json, yaml