How to Restore a Table Backed up to an NFS Mount

Products

• VMware Tanzu Greenplum

Issue/Introduction

This article describes how to restore a table that has been backed up to an NFS mount.

 

Environment

Resolution

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

Additional Information

+ Environment:

Pivotal Greenplum Database (GPDB)