Display information about existing backups, delete existing backups, or encrypt passwords for secure storage in plugin configuration files.
gpbackup_manager utility is available only in the commercial release of Tanzu Greenplum Backup and Restore.
where command is:
delete-backup <timestamp> [--plugin-config <config-file>] | display-report <timestamp> | encrypt-password --plugin-config <config-file> | list-backups | replicate-backup <timestamp> --plugin-config <config-file> | help [<command>]
--plugin-config config-fileoption specifies the DD Boost configuration file that contains the information to access the backup and the remote Data Domain server. For information about the configuration file, see Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager. For information about replicating backups, see Replicating Backups
delete-backupcommand requires this option if the backup is stored in S3 or a Data Domain system. The
encrypt-passwordcommand requires this option. Note: When you delete backup sets stored in a Data Domain system, you must pass in the same configuration file that was passed in when the backups were created. Otherwise, the
gpbackup_manager delete-backupcommand will exit with an error.
Displays a help message for the
gpbackup_manager command. For help on a specific
gpbackup_manager command, enter
gpbackup_manager help command. For example:
$ gpbackup_manager help encrypt-password
gpbackup_manager utility manages backup sets created using the
gpbackup utility. You can list backups, display a report for a backup, and delete a backup.
gpbackup_manager can also encrypt passwords to store in a DD Boost plugin configuration file.
Greenplum Database must be running to use the
Backup history is saved on the Greenplum Database master host in the file
$MASTER_DATA_DIRECTORY/gpbackup_history.yaml. If no backups have been created yet, or if the backup history has been deleted,
gpbackup_manager commands that depend on the file will display an error message and exit. If the backup history contains invalid YAML syntax, a yaml error message is displayed.
gpbackup earlier than v1.13.0 did not save the backup duration in the backup history file. The
list-backups command duration column is empty for these backups.
encrypt-password command is used to encrypt Data Domain user passwords that are saved in a DD Boost plug-In configuration file. To use this option, the
pgcrypto extension must be enabled in the Greenplum Database
postgres database. See the Tanzu Greenplum Backup and Restore installation instructions for help installing
encrypt-password command prompts you to enter and then re-enter the password to be encrypted. To maintain password secrecy, characters entered are echoed as asterisks. If replication is enabled in the specified DD Boost configuration file, the command also prompts for a password for the remote Data Domain account. You must then copy the output of the command into the DD Boost configuration file.
The following table describes the contents of the columns in the list that is output by the
gpbackup_manager list-backups command.
|timestamp||Timestamp value (
|date||Date the backup was taken.|
|status||Status of the backup operation,
|database||Name of the database backed up (specified on the
|type||Which classes of data are included in the backup. Can be one of the following:
|object filtering||The object filtering options that were specified at least once on the
|plugin||The name of the binary plugin file that was used to configure the backup destination, excluding path information.|
|duration||The amount of time (
|date deleted||Indicates the status of the deletion. If blank, the backup still exists. Other possible values include:
Display a list of the existing backups.
gpadmin@mdw:$ gpbackup_manager list-backups timestamp date status database type object filtering plugin duration date deleted 20210721191330 Wed Jul 21 2021 19:13:30 Success sales full gpbackup_ddboost_plugin 00:20:25 In progress 20210721191201 Wed Jul 21 2021 19:12:01 Success sales full gpbackup_ddboost_plugin 00:15:21 Plugin Backup Delete Failed 20210721191041 Wed Jul 21 2021 19:10:41 Success sales full gpbackup_ddboost_plugin 00:10:25 Local Delete Failed 20210721191022 Wed Jul 21 2021 19:10:22 Success sales full include-schema 00:02:35 Wed Jul 21 2021 19:24:59 20210721190942 Wed Jul 21 2021 19:09:42 Success sales full exclude-schema 00:01:11 20210721190826 Wed Jul 21 2021 19:08:26 Success sales data-only 00:05:17 20210721190818 Wed Jul 21 2021 19:08:18 Success sales metadata-only 00:01:01 20210721190727 Wed Jul 21 2021 19:07:27 Success sales full 00:07:22
Display the backup report for the backup with timestamp 20190612154608.
$ gpbackup_manager display-report 20190612154608 Greenplum Database Backup Report Timestamp Key: 20190612154608 GPDB Version: 5.14.0+dev.8.gdb327b2a3f build commit:db327b2a3f6f2b0673229e9aa164812e3bb56263 gpbackup Version: 1.11.0 Database Name: sales Command Line: gpbackup --dbname sales Compression: gzip Plugin Executable: None Backup Section: All Sections Object Filtering: None Includes Statistics: No Data File Format: Multiple Data Files Per Segment Incremental: False Start Time: 2019-06-12 15:46:08 End Time: 2019-06-12 15:46:53 Duration: 0:00:45 Backup Status: Success Database Size: 3306 MB Count of Database Objects in Backup: Aggregates 12 Casts 4 Constraints 0 Conversions 0 Database GUCs 0 Extensions 0 Functions 0 Indexes 0 Operator Classes 0 Operator Families 1 Operators 0 Procedural Languages 1 Protocols 1 Resource Groups 2 Resource Queues 6 Roles 859 Rules 0 Schemas 185 Sequences 207 Tables 431 Tablespaces 0 Text Search Configurations 0 Text Search Dictionaries 0 Text Search Parsers 0 Text Search Templates 0 Triggers 0 Types 2 Views 0
Delete the local backup with timestamp 20190620145126.
$ gpbackup_manager delete-backup 20190620145126 Are you sure you want to delete-backup 20190620145126? (y/n)y Deletion of 20190620145126 in progress. Deletion of 20190620145126 complete.
Delete a backup stored on a Data Domain system. The DD Boost plugin configuration file must be specified with the
$ gpbackup_manager delete-backup 20190620160656 --plugin-config ~/ddboost_config.yaml Are you sure you want to delete-backup 20190620160656? (y/n)y Deletion of 20190620160656 in progress. Deletion of 20190620160656 done.
Encrypt a password. A DD Boost plugin configuration file must be specified with the
$ gpbackup_manager encrypt-password --plugin-config ~/ddboost_rep_on_config.yaml Please enter your password ****** Please verify your password ****** Please enter your remote password ****** Please verify your remote password ****** Please copy/paste these lines into the plugin config file: password: "c30d04090302a0ff861b823d71b079d23801ac367a74a1a8c088ed53beb62b7e190b7110277ea5b51c88afcba41857d2900070164db5f3efda63745dfffc7f2026290a31e1a2035dac" password_encryption: "on" remote_password: "c30d04090302c764fd06bfa1dade62d2380160a8f1e4d1ff0a4bb25a542fb1d31c7a19b98e9b2f00e7b1cf4811c6cdb3d54beebae67f605e6a9c4ec9718576769b20e5ebd0b9f53221" remote_password_encryption: "on"
Parent topic:Backup Utility Reference