11
Backup and Recovery
Most people admit that backups are essential, though they also devote a very small amount of time to thinking about the topic.
The first recipe in this chapter is about understanding and controlling crash recovery. You need to understand what happens if a database server crashes so that you can understand whether you need to perform a recovery operation.
The next recipe is all about planning. That’s really the best place to start before you perform backups.
The physical backup mechanisms were initially written by Simon Riggs (one of the authors of this book) for PostgreSQL 8.0 in 2004, and have been supported by him ever since, with ever-increasing help from the community as Postgres’s popularity grew. 2ndQuadrant and ...
Get PostgreSQL 16 Administration Cookbook 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.
