Utility Reference
The command-line utilities provided with SynxDB.
SynxDB uses the standard PostgreSQL client and server programs and provides additional management utilities for administering a distributed SynxDB DBMS.
Several utilities are installed when you install the SynxDB server. These utilities reside in $GPHOME/bin
. Other utilities may be installed separately.
SynxDB 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 SynxDB server, unless specifically identified by a superscript.
- analyzedb
- clusterdb
- createdb
- createuser
- dropdb
- dropuser
- gpactivatestandby
- gpaddmirrors
- gpbackup
- gpcheckcat
- gpcheckperf
- gpconfig
- cbcopy
- gpdeletesystem
- gpexpand
- gpfdist
- gpinitstandby
- gpinitsystem
- gpload
- gplogfilter
- gpmapreduce
- gpmapreduce.yaml
- gpmovemirrors
- gppkg
- gprecoverseg
- gpreload
- gprestore
- gpscp
- gpssh
- gpssh-exkeys
- gpstart
- gpstate
- gpstop
- pg_config
- pg_dump
- pg_dumpall
- pg_restore
- pgbouncer
- pgbouncer.ini
- plcontainer
- plcontainer Configuration File
- psql
- pxf
- pxf cluster
- reindexdb
- vacuumdb