Utility Reference

The command-line utilities provided with Greenplum Database.

Greenplum Database uses the standard PostgreSQL client and server programs and provides additional management utilities for administering a distributed Greenplum Database DBMS.

Several utilities are installed when you install the Greenplum Database server. These utilities reside in $GPHOME/bin. Other utilities must be downloaded from Broadcom Support Portal and installed separately. These include:

• The VMware Greenplum Backup and Restore utilities.
• The VMware Greenplum Copy Utility.
• The VMware Greenplum Streaming Server utilities.

Additionally, the VMware Greenplum Clients package is a separate download from Broadcom Support Portal that includes selected utilities from the Greenplum Database server installation that you can install on a client system.

Note

For more information about download prerequisites, troubleshooting, and instructions, see Download Broadcom products and software.

Greenplum Database provides the following utility programs. Superscripts identify those utilities that require separate downloads, as well as those utilities that are also installed with the Client and Loader Tools Packages. (See the Note following the table.) All utilities are installed when you install the Greenplum Database server, unless specifically identified by a superscript.

• analyzedb
• clusterdb
• createdb³
• createuser³
• dropdb³
• dropuser³
• gpactivatestandby
• gpaddmirrors
• gpbackup_manager¹
• gpbackup¹
• gpcheckcat
• gpcheckperf
• gpconfig
• gpcopy²
• gpdeletesystem
• gpexpand
• gpfdist³
• gpinitstandby
• gpinitsystem
• gpkafka⁴
• gpload³
• gplogfilter
• gpmovemirrors
• gpsupport
• gppkg
• gpdr
• gprecoverseg
• gpreload
• gprestore¹
• gpss⁴
• gpssh
• gpssh-exkeys
• gpstart
• gpstate
• gpstop
• gpsync
• gpv
• pg_config
• pg_dump³
• pg_dumpall³
• pg_filedump
• pg_restore
• pgbouncer
• pgbouncer.ini
• pgbouncer-admin
• plcontainer
• plcontainer Configuration File
• psql³
• pxf
• pxf cluster
• reindexdb
• vacuumdb

Note

¹ The utility program can be obtained from VMware Tanzu Greenplum Backup and Restore on Broadcom Support Portal.

² The utility program can be obtained from VMware Tanzu Greenplum Data Copy Utility on Broadcom Support Portal.

³ The utility program is also installed with the Greenplum Client and Loader Tools Package for Linux and Windows. You can obtain these packages from VMware Tanzu Greenplum on Broadcom Support Portal.

⁴ The utility program is also installed with the Greenplum Client and Loader Tools Package for Linux. You can obtain the most up-to-date version of the VMware Tanzu Greenplum Streaming Server from Broadcom Support Portal.