O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Recovery with Barman

This recipe assumes that you have read the previous recipe, Hot physical backups with Barman, and successfully installed Barman on the malcolm server, backing up the Postgres databases running on angus and bon. We will use the same nomenclature in the examples of this recipe.

A recovery procedure is a reaction to a failure. In database terms, this could be related to an unintentional human error (for example, DROP operation of a table), an attack (think of Little Bobby Tables), a hardware failure (for example, a broken hard drive), or—less likely—a natural disaster.

Even though you might be tempted to think that you are immune to disasters or failures (I wish you were), you are advised to perform regular tests and simulations ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required