About the Tools Package
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:
| 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. |
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.