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.