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