Greenplum Database Utilities Book Preview for your future reference purpose.
Here are the list of Greenplum database management utilities as of V 3.0. Some of the old utilities are deprecated and mentioned at the bottom of the page. I will describe each utilities in more details in my future blogs. You can also buy my ebook
1. gpactivatestandby: Activates a standby master host and makes it the active master for the Greenplum Database system.
2. gpaddmirrors: Adds mirror segments to a Greenplum Database system that was initially configured without mirroring.
3. gpbitmapreindex: Rebuilds bitmap indexes after a 3.3.x to 4.0.x upgrade.
4. gpcheck: Verifies and validates Greenplum Database platform settings.
5. gpcheckperf: Verifies the baseline hardware performance of the specified hosts.
6. gpcrondump: Writes out a database to SQL script files. The script files can be used to restore the database using the gpdbrestore utility. The gpcrondump utility can be called directly or from a crontab entry.
7. gpconfig: Sets server configuration parameters on all segments within a Greenplum Database system.
8. gpdbrestore: Restores a database from a set of dump files generated by gpcrondump.
9. gpdeletesystem: Deletes a Greenplum Database system that was initialized using gpinitsystem.
10. gpdetective: Collects diagnostic information from a running Greenplum Database system.
11. gp_dump: Writes out a database to SQL script files, which can then be used to restore the database using gp_restore.
12. gpexpand: Expands an existing Greenplum Database across new hosts in the array.
13. gpfdist: Serves data files to or writes data files out from Greenplum Database segments.
14. gpfilespace: Creates a filespace using a configuration file that defines per-segment file system locations. Filespaces describe the physical file system resources to be used by a tablespace.
15. gpinitstandby: Adds and/or initializes a standby master host for a Greenplum Database system.
16. gpinitsystem: Initializes a Greenplum Database system using configuration parameters specified in the gpinitsystem_config file.
17. gpload: Runs a load job as defined in a YAML formatted control file.
18. gplogfilter: Searches through Greenplum Database log files for specified entries.
19. gpmapreduce: Runs Greenplum MapReduce jobs as defined in a YAML specification document.
20. gpmfr: Manages the Greenplum Database backup images that are stored on a local Data Domain system and a remote Data Domain system that is used for disaster recovery. Managed file replication is used for disaster recovery by the Data Domain Boost software option to transfer a backup image from one Data Domain system to another.
21. gpmigrator: Upgrades an existing Greenplum Database 4.1.x system without mirrors to 4.3.x.
Use gpmigrator_mirror to upgrade a 4.1.x system that has mirrors. Note: Using gpmigrator on a system with mirrors causes an error.
22. gpmigrator_mirror: Upgrades an existing Greenplum Database 4.1.x system with mirrors to 4.3.x. Use gpmigrator to upgrade a 4.1.x system that does not have mirrors. Note: Using gpmigrator_mirror on a system without mirrors causes an error.
23. gppkg: Installs Greenplum Database extensions such as pgcrypto, PL/R, PL/Java, PL/Perl, PostGIS, and MADlib, along with their dependencies, across an entire cluster.
24. gprecoverseg: Recovers a primary or mirror segment instance that has been marked as down (if mirroring is enabled).
25. gp_restore: Restores Greenplum databases that were backed up using gp_dump. The gp_restore utility is deprecated and will be removed in a future release. Use gpcrondump and gpdbrestore to backup and restore Greenplum databases.
26. gpscp: Copies files between multiple hosts at once.
27. gpseginstall: Installs Greenplum Database on segment hosts.
28. gpsnmpd: Reports on the health and state of a Greenplum Database system through SNMP.
29. gpssh: Provides ssh access to multiple hosts at once.
30. gpssh-exkeys: Exchanges SSH public keys between hosts.
31. gpstart: Starts a Greenplum Database system.
32. gpstate: Shows the status of a running Greenplum Database system.
33. gpstop: Stops or restarts a Greenplum Database system.
34. gpsys1: Displays information about your operating system.
Following utilities are deprecated as of Greenplum v 4.3
1. gpchecknet (deprecated)
2. gpcheckos (deprecated)
3. gprebuildsystem (deprecated)
4. gpsizecalc (deprecated)
5. gpskew (deprecated)