Utility Reference v6.27.4

The command-line utilities provided with WarehousePG.

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

Several utilities are installed when you install the WarehousePG server. These utilities reside in $GPHOME/bin. Other utilities must be downloaded and installed separately. These include:

• The WarehousePG Backup and Restore utilities.

WarehousePG 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 WarehousePG server, unless specifically identified by a superscript.

• analyzedb
• clusterdb
• createdb
• createuser
• dropdb
• dropuser
• gpactivatestandby
• gpaddmirrors
• gpcheckcat
• gpcheckperf
• gpconfig
• gpdeletesystem
• gpexpand
• gpfdist
• gpinitstandby
• gpinitsystem
• gpload
• gplogfilter
• gpmapreduce
• gpmapreduce.yaml
• gpmovemirrors
• gprecoverseg
• gpreload
• gpscp
• gpssh
• gpssh-exkeys
• gpstart
• gpstate
• gpstop
• pg_config
• pg_dump
• pg_dumpall
• pg_restore
• pgbouncer
• pgbouncer.ini
• psql
• reindexdb
• vacuumdb

Additional utilities may be found at WarehousePG Github Org Repo