Reference：commands#

OushuDB 提供如下的命令行工具，所有的 OushuDB 命令行都具有帮助文档，请运行下面命令得到详细帮助：

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.

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

gplogfilter#

Searches through OushuDB log files for specified entries.

oushudb#

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

 The most commonly used OushuDB "commands" are:
    start         Start OushuDB service.
    stop          Stop OushuDB service.
    init          Init OushuDB service.
    restart       Restart OushuDB service.
    version       Show OushuDB version information.
    config        Set OushuDB GUC values.
    state         Show OushuDB cluster status.
    filespace     Create OushuDB filespaces.
    extract       Extract table's metadata into a YAML formatted file.
    load          Load data into OushuDB.
    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 OushuDB settings.
    checkperf     Verifies the baseline hardware performance of hosts.
    register      Register parquet files generated by other system into the corrsponding table in OushuDB
    reload        Reload GUC values without restarting OushuDB cluster.
    backup        Backup OushuDB metadata and user data.
    restore       Restore OushuDB metadata and user data.
    import        Import metadata increment into OushuDB.

 See 'oushudb <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