verify-settings =============== Verifies the EDB Postgres Distributed cluster settings. Synopsis ^^^^^^^^ Verifies the EDB Postgres Distributed cluster settings. .. code:: sh pgd verify-settings [flags] Examples ^^^^^^^^ .. code:: text 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 ^^^^^^^ .. code:: text -h, --help help for verify-settings Options inherited from parent commands ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ .. code:: text -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