verify-settings v5.6
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