verify-settings v5

pgd verify-settings [flags]

  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

  -h, --help   help for verify-settings

  -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