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.ddl_locking Ok: all node values are ok # bdr.max_writers_per_subscription Ok: all node values are ok # 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 Warning false -1 must be >= 1 logical-standby-b1 Warning false -1 must be >= 1 subscriber-only-c1 Warning false -1 must be >= 1 witness-a Warning false -1 must be >= 1 witness-b Warning false -1 must be >= 1 witness-c Warning false -1 must be >= 1 # bdr.xact_replication Ok: all node values are ok # 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_statements, bdr must contain bdr as first entry bdr-a2 Warning false pg_stat_statements, bdr must contain bdr as first entry bdr-b1 Warning false pg_stat_statements, bdr must contain bdr as first entry bdr-b2 Warning false pg_stat_statements, bdr must contain bdr as first entry logical-standby-a1 Warning false pg_stat_statements, bdr must contain bdr as first entry logical-standby-b1 Warning false pg_stat_statements, bdr must contain bdr as first entry subscriber-only-c1 Warning false pg_stat_statements, bdr must contain bdr as first entry witness-a Warning false pg_stat_statements, bdr must contain bdr as first entry witness-b Warning false pg_stat_statements, bdr must contain bdr as first entry witness-c Warning false pg_stat_statements, bdr 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