Recovery of all databases
Recovery of a complete database server, including all of its databases, is an important feature. This recipe covers how to do that in the simplest way possible.
Some complexities are discussed here, though most are covered in later recipes.
Getting ready
Find a suitable server on which to perform the restore.
Before you recover onto a live server, always take another backup. Whatever problem you thought you had could just be about to get worse.
How to do it…
Here, we'll provide three distinct examples, depending on what type of backup was taken.
Logical – from the custom dump taken with pg_dump -F c
The procedure is as follows:
- Restore of all databases means simply restoring each individual database from each dump you took. Confirm ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
