command-name --help


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 orDDL 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.


Creates a database.


Creates a new role.


Removes a database.


Removes a role.


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


Searches through OushuDB log files for specified entries.


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

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 OushuDB

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.