Can anyone tell me why is the gp_dump utility is not available with greenplum database by default? If I have to use it then what is the source to download and way to enable it? I have gone through a lot of online resources but nothing relevant could be found
Are you using Greenplum v6.x?
The latest version of gpbackup is located here:
https://github.com/greenplum-db/gpbackup/releases
and if interested, the corresponding s3 plugin here: https://github.com/greenplum-db/gpbackup-s3-plugin
gp_dump is a very old, deprecated backup utility for Greenplum.
The older python based gpcrondump/gpdbrestore utilities are still bundled in Greenplum 4.3.x and 5.x versions, but do not support Greenplum 6.x and thus removed.
The newer Golang based gpbackup/gprestore utilities support Greenplum 4.3.22 and later, Greenplum 5.5 and later and Greenplum 6.0 and later all in the same binary.
Let me know if you have additional questions.