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 Broadcom Support Portal under the specific Greenplum release.
NoteFor more information about download prerequisites, troubleshooting, and instructions, see Download Broadcom products and software.
Greenplum utility programs provided in the client and loader tools package include:
| Program | Description |
|---|---|
| createdb | Create a Greenplum database. Requires superuser or specially-granted Greenplum Database privileges. |
| createuser | Register a Greenplum user. Requires superuser or specially-granted Greenplum Database privileges. |
| dropdb | Drop a Greenplum database. Requires superuser or specially-granted Greenplum Database privileges. |
| dropuser | Remove a Greenplum user. Requires superuser or specially-granted Greenplum Database privileges. |
| gpfdist | Greenplum parallel file distribution program. |
| gpkafka | Load Kafka data into Greenplum Database using the VMware Tanzu Greenplum Streaming Server. |
| gpload | Greenplum data loading utility. |
| gpss | Start a VMware Tanzu Greenplum Streaming Server instance. |
| gpsscli | VMware Tanzu Greenplum Streaming Server client program. |
| pg_dump | Dump the contents of a Greenplum database to a file. |
| pg_dumpall | Dump the contents of all Greenplum databases to a file. |
| psql | PostgreSQL interactive command-line interface for Greenplum Database. |
NoteThe Windows Greenplum client and loader tools package provides additional libraries and programs, including
kinit,kdestroy, andklist. The Windows package does not include thegpkafka,gpsscli, andgpssprograms.
The gpload program provided in the Windows package is backwards-compatible with Greenplum Database 5.
