postgres skip table from restore
Restore done in 3 steps:
- 1.Generate task listpg_restore -l dump-path/ > task
- 2.Edit the generated
task file
and remove the step that we wanted to ignore. Example, if we want to skip the restoringsometable
, we remove this line from the file.4749; 0 106924 TABLE DATA public sometable someuser - 3.Restore using the task filepg_restore -d somedatabase -L ./task dump-path/