HAWQ provides the following command-line tools, all HAWQ command has a help, you can run the following command to get detailed help information：
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:
- 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.
- Views, indices and external tables are automatically skipped.
- Table names or schema names containing comma or period is not supported yet.
Creates a database.
Creates a new role.
Removes a database.
Removes a role.
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.
Searches through HAWQ log files for specified entries.
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 dumps a database as a text file or to other formats.
pg_dumpall extracts a PostgreSQL database cluster into an SQL script file.
pg_restore restores a PostgreSQL database from an archive created by pg_dump.
The PostgreSQL interactive terminal
vacuumdb cleans and analyzes a database.