Reference: commands

HAWQ provides the following command-line tools, all HAWQ command has a help, you can run the following command to get detailed help information:

command-name --help

analyzedb

Analyze a database incrementally. ‘Incremental’ means if a table or partition has not been modified byDML or DDL commands since the last analyzedb run, it will be automatically skipped since its statisticsmust be up to date. Some restrictions apply:

  1. The incremental semantics only applies to append-only tables or partitions. All heap tables are regardedas having stale stats every time analyzedb is run. This is because we use AO metadata to check for DML or DDL events, which is not available to heap tables.
  2. Views, indices and external tables are automatically skipped.
  3. Table names or schema names containing comma or period is not supported yet.

createdb

Creates a database.

createuser

Creates a new role.

dropdb

Removes a database.

dropuser

Removes a role.

gpfdist

gpfdist is the HAWQ parallel file distribution program. It is used by readable external tables and gpload to serve external table files to all HAWQ segments in parallel. It is used by writable external tables to accept output streams from HAWQ segments in parallel and write them out to a file.

gplogfilter

Searches through HAWQ log files for specified entries.

hawq

usage: hawq <command> [<object>] [options]
         [--version]

The most commonly used hawq "commands" are:
   start         Start hawq service.
   stop          Stop hawq service.
   init          Init hawq service.
   restart       Restart hawq service.
   activate      Activate hawq standby master as master.
   version       Show hawq version information.
   config        Set hawq GUC values.
   state         Show hawq cluster status.
   filespace     Create hawq filespaces.
   extract       Extract table metadata into a YAML formatted file.
   load          Load data into hawq.
   scp           Copies files between multiple hosts at once.
   ssh           Provides ssh access to multiple hosts at once.
   ssh-exkeys    Exchanges SSH public keys between hosts.
   check         Verifies and validates HAWQ settings.
   checkperf     Verifies the baseline hardware performance of hosts.
   register      Register parquet files generated by other system into the corrsponding table in HAWQ

See 'hawq <command> help' for more information on a specific command.

pg_dump

pg_dump dumps a database as a text file or to other formats.

pg_dumpall

pg_dumpall extracts a PostgreSQL database cluster into an SQL script file.

pg_restore

pg_restore restores a PostgreSQL database from an archive created by pg_dump.

psql

The PostgreSQL interactive terminal

svacuumdb

vacuumdb cleans and analyzes a database.