- Pivotal Greenplum (GPDB) all versions
- Operating System- Red Hat Enterprise Linux (RHEL) 6.x
Running gp_restore fails with an error similar to the following:
Error executing query SELECT * FROM gp_read_backup_file('db_dumps/20150528', '20150528141109', 2) : ERROR: Backup File /mnt/data1/primary/gp5/db_dumps/20150528/gp_restore_status_0_7_20150528141109 Type 2 could not be found
gp_restore needs write permissions to the backup directory. gp_restore tries to create/write a status file and if it is not able to, it will fail with the error above.
If you see this error, make sure that the user under which GPDB/gp_restore running can write and update files in the backup directory. This is especially important if the backup directory is mounted from another location.
Note- "Type 2" above is simply a notion that the file that could not be found is a gp_restore "status" file. "Type 1" corresponds to a backup "status" file.