Restore a Greenplum database
This topic describes how to restore to a different database.
To restore a Greenplum database
- Create a
yamlfile from the examplenbgpbackup_config.yamlfile. - 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.