Shows the status of a running HAWQ system.
hawq state [-b] [-l log_directory] [-v | -q] [-d master_data_directory] [--hawqhome] hawq state -? | -h | --help
hawq state utility displays information about a running HAWQ instance. A HAWQ system is comprised of multiple PostgreSQL database instances (segments) spanning multiple machines, and the
hawq state utility can provide additional status information, such as:
- Total segment count.
- Which segments are down.
- Master and segment configuration information (hosts, data directories, etc.).
- The ports used by the system.
- Whether a standby master is present, and if it is active.
-b (brief status)
Optional. Display a brief summary of the state of the HAWQ system. This is the default option.
-d master_data_directory –datadir=MASTER_DIR
Status of the master data directory. If not specified, the value set for
$MASTER_DATA_DIRECTORY will be used.
Display details of the designated home data directory.
Displays calls to the log file. Defaults to
-q (no screen output)
Optional. Run in quiet mode. Except for warning messages, command output is not displayed on the screen. However, this information is still written to the log file.
-v (verbose output)
Optional. Displays error messages and outputs detailed status and progress information.
-? | -h | –help (help)
Displays the online help.
Show brief status information of a HAWQ system:
hawq state -b