How do I restore a partial backup or single table using Postgres?


You'd like to restore part of a database dump instead of restoring all the tables.


It's possible to establish a connection from a local machine to your Heroku Postgres instance to use pg_restore. This Dev Center article describes how to restore using the pg_restore command in general. This article covers connecting to your database from your local machine.

To restore a single table you can use the -t option in the pg_restore command. The full pg_restore documentation is available here.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support