verify-settings v5.6
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.
Verifies the EDB Postgres Distributed cluster settings.
Synopsis
Verifies the EDB Postgres Distributed cluster settings.
pgd verify-settings [flags]
Options
No specific command options. See global options for global options.
Examples
Verifying the cluster settings
$ 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