postgres skip table from restore

Restore done in 3 steps:

  1. Generate task list

    pg_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 restoring sometable, we remove this line from the file.

    4749; 0 106924 TABLE DATA public sometable someuser
  3. Restore using the task file

    pg_restore -d somedatabase -L ./task dump-path/

Last updated