To recover a single database from a physical backup, you need to work on a separate PostgreSQL server (for recovery or staging purposes) and then you must:
- Recover the database server in full, as described in the previous recipes on physical recovery, including all databases and all tables. You may wish to stop at a useful point in time, in which case you can look at the Recovery to a point in time recipe, earlier in the chapter.
- Once the restore is complete, you can dump the tables in the database by following the Hot logical backups of one database recipe.
- Now, recreate the database on the original server as described for logical dumps earlier in this recipe.