hawq state

Shows the status of a running HAWQ system.

Synopsis

hawq state 
     [-b]
     [-l <logfile_directory> | --logdir <logfile_directory>]
     [(-v | --verbose) | (-q | --quiet)]  
hawq state [-h | --help]

Description

The 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.
• Whether Ranger authorization is enabled for HAWQ, and if so, the status of the HAWQ Ranger Plug-in Service.

Options

-b (brief status)

Display a brief summary of the state of the HAWQ system. This is the default mode.

-l, —logdir

Specifies the directory to check for logfiles. The default is $GPHOME/hawqAdminLogs.

Log files within the directory are named according to the command being invoked, for example: hawq_config_.log, hawq_state_.log, etc.

-q, —quiet

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

Displays error messages and outputs detailed status and progress information.

-h, —help (help)

Displays the online help.

Examples

Show brief status information of a HAWQ system:

$ hawq state -b

Change the log directory from hawqAdminLogs to TodaysLogs.

$ hawq state -l TodaysLogs
$ ls TodaysLogs
hawq_config_20160707.log  hawq_init_20160707.log   master.initdb

See Also

hawq start, gplogfilter