A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

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

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

Table 1. Client and Loader Programs
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 Kafa data into Greenplum Database using the Pivotal Greenplum-Kafka Integration.
gpload	Greenplum data loading utility.
gpss	Start a Pivotal Greenplum Stream Server instance.
gpsscli	Pivotal Greenplum Stream 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.