Please enter search query.
Search <book_title>...
NetBackup™ for Greenplum Administrator's Guide
Last Published:
2025-03-18
Product(s):
NetBackup & Alta Data Protection (11.0)
- Introducing NetBackup for Greenplum
- Installing NetBackup for Greenplum
- Configuring NetBackup for Greenplum
- About configuring a backup policy for Greenplum
- About the backup script for NetBackup for Greenplum
- Using NetBackup for Greenplum
- Troubleshooting NetBackup for Greenplum
- Appendix A. Register authorized locations
Restore a Greenplum database
This topic describes how to restore to a different database.
To restore a Greenplum database
- Create a
yaml
file from the examplenbgpbackup_config.yaml
file. - On the coordinator, determine which timestamp that you want to restore to. Use the bplist command:
/usr/openv/netbackup/bin/bplist -l -t 24 -C client -S server -unix_files -R 999 /
The timestamp is the directory name before the file. For example:
/data/coordinator/gpseg-1/backups/20241107/20241107135750/ gpbackup_20241107135750_report
In the previous line, the timestamp is
20241107135750
. - On the coordinator, run the gprestore command.
gprestore --plugin-config path_to_yaml_file --timestamp timestamp --redirect-db restoredb --create-db
The value for timestamp should match the timestamp that you found in step 2. For example,
20241107135750
.