Chapter 5. Backup and Recovery
In this chapter, you will learn all you need to know about backup and recovery in PostgreSQL. The following topics will be covered in this chapter:
- Importing and exporting data
- Performing simple dumps
- Creating efficient custom-format dumps
- Replaying dumps
- Scaling up replay
Importing and exporting data
Before actually diving into backup and recovery, it is useful to take a general look at importing and exporting data from, and into, PostgreSQL. Understanding imports and exports is quite essential to get the overall idea of backups on a technical level.
Using the COPY command
When talking about imports and exports, there is really no way to do it without discussing the COPY command. The COPY command is the backbone of all the ...
Get PostgreSQL Administration Essentials 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.
