Is there a way to exclude certain indices when restoring a database? I see that there is no option to do this in pg_restore, but I was hoping there may be some other way.

  • 3
    Create a list file from pg_restore --list, edit that file to comment out the indexes you want to omit, then run pg_restore -L. That's assuming your backup is in custom format of course.
    – bma
    Commented Apr 5, 2017 at 14:42


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.