About the Tools Package
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. |
| createlang | Register a language in 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. |
| droplang | Remove support for a language from 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.