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