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 - PostgreSQL Tutorial
From the course: PostgreSQL: Client Applications
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Create backups with pg_dump4m 9s
-
(Locked)
Configure backup options3m 36s
-
(Locked)
Data-only and schema-only backups3m 10s
-
(Locked)
Create a backup of a single table2m 51s
-
(Locked)
Restoring plain-text backups2m 38s
-
(Locked)
Custom archive backup files3m 45s
-
(Locked)
Restoring database archives with pg_restore4m 21s
-
(Locked)
Partial database restores5m 53s
-
(Locked)
-