From the course: PostgreSQL: Client Applications

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Partial database restores

Partial database restores

- [Instructor] In order to partially restore a database from an archive file. We need to understand exactly what's in the custom archive. We can get that information with the dash lowercase L option for PG restore. I'll start PG restore command with our typical local hosts and Postgres user account and I'll add the dash lowercase L option. Then I Just need to make a reference to the dump file that we exported in the previous movie. I have saved a copy of that in the chapter five folder of the exercise files, and it's called two_trees.dump. When I press Enter, it prints out a listing called the table of contents and it gives us a good overview about what that archive contains. If I scroll up to the top, we'll get some information about exactly when that archive was created, as well as the original database name that it came from. Below that we have some table of contents entries. This displays an overview of the major components. We have the various schemas that are in the database…

Contents