Cluster Utilities Guide
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 such as clients and backup/restore may be found at Warehouse PG Github Repo
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
- createdb1
- createuser1
- dropdb1
- dropuser1
- gpactivatestandby
- gpaddmirrors
- gpbackup2
- gpcheckcat
- gpcheckperf
- gpconfig
- gpdeletesystem
- gpexpand
- gpfdist1
- gpinitstandby
- gpinitsystem
- gpload1
- gplogfilter
- gpmovemirrors
- gprecoverseg
- gpreload
- gprestore2
- gpssh
- gpssh-exkeys
- gpstart
- gpstate
- gpstop
- gpsync
- pg_config
- pg_dump1
- pg_dumpall1
- pg_restore
- pgbouncer
- pgbouncer.ini
- pgbouncer-admin
- psql1
- pxf
- pxf cluster
- reindexdb
- vacuumdb
Note
1 The utility program is also installed with the WarehousePG Client and Loader Tools Package
2 The utility program can be obtained from the WarehousePG Backup and Restore
Additional utilities may be found at Warehouse PG Github Org Repo
Parent topic: WarehousePG Utility Guide