The Greenplum client and loader tools package provides utility programs that you can install and run on a host outside of your Greenplum Database cluster. The package is available on VMware Tanzu Network.

    Greenplum utility programs provided in the client and loader tools package include:

    ProgramDescription
    createdbCreate a Greenplum database. Requires superuser or specially-granted Greenplum Database privileges.
    createuserRegister a Greenplum user. Requires superuser or specially-granted Greenplum Database privileges.
    dropdbDrop a Greenplum database. Requires superuser or specially-granted Greenplum Database privileges.
    dropuserRemove a Greenplum user. Requires superuser or specially-granted Greenplum Database privileges.
    gpfdistGreenplum parallel file distribution program.
    gpkafkaLoad Kafka data into Greenplum Database using the VMware Tanzu Greenplum Streaming Server.
    gploadGreenplum data loading utility.
    gpssStart a VMware Tanzu Greenplum Streaming Server instance.
    gpsscliVMware Tanzu Greenplum Streaming Server client program.
    pg_dumpDump the contents of a Greenplum database to a file.
    pg_dumpallDump the contents of all Greenplum databases to a file.
    psqlPostgreSQL interactive command-line interface for Greenplum Database.

    Note

    The Windows Greenplum client and loader tools package provides additional libraries and programs, including kinit, kdestroy, and klist. The Windows package does not include the gpkafka, gpsscli, and gpss programs.

    The gpload program provided in the Windows package is backwards-compatible with Greenplum Database 5.