Pivotal Knowledge Base

Follow

How to restore a table backed up to an NFS mount

Goal

Need to restore a table that has been backed up to a NFS mount.

Solution

When restoring a table that has been backed up to an NFS mount you will need to follow the following step to complete this task:

1. Create a file on all Pivotal Greenplum Servers that will contain the name of the table that you want to restore

2. The following is the command you will need to run to restore the table:

gp_restore -d DATABASE_NAME -a --gp-d=/NFS_MOUNT/db_dumps/DATE_OF_BACKUP/ --gp-k=TIMESTAMP_OF_BACKUP --gp-f=/LOCATION_OF_TABLE_FILE_TO_BE_RESTORED --gp-c

example:

gp_restore -d test -a --gp-d=/backup/db_dumps/20130610 --gp-k=20130610192136 --gp-f=/home/gpadmin/backupfile --gp-c

Comments

Powered by Zendesk