O'Reilly logo

PostgreSQL Developer's Handbook by Hans-Jürgen Schönig, Ewald Geschwinde

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

Chapter 7. Backup and Recovery

Every database administrator has to take care of backups. In case of disaster, backups are essential for restoring data. But not only hard- and software errors demand backup strategies. Sometimes a user deletes files accidentally, and it is the administrator's task to restore these files.

In this chapter, you learn to back up PostgreSQL databases and see how data can be restored.

Common Errors

Mastering backups and recovery is perhaps one of the most important areas of database administration. However, the maintenance of restorable copies can, in many cases, be very difficult—especially on systems that have to do a lot of INSERT and UPDATE operations.

In general, you can make four mistakes when working with a database ...

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