Pivotal Knowledge Base

Follow

How to Restore a Table Backed up to an NFS Mount

Environment

Pivotal Greenplum Database (GPDB)

Purpose

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

Procedure

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