This article describes how to restore a table that has been backed up to an NFS mount.
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
gp_restore -d test -a --gp-d=/backup/db_dumps/20130610 --gp-k=20130610192136 --gp-f=/home/gpadmin/backupfile --gp-c