In the previous chapter of this book, I tried to teach you all you need to know about securing PostgreSQL in the most simplistic and most beneficial way possible. The topics of this chapter will be backup and recovery. Performing backups should be a regular task and every administrator is supposed to keep an eye on this vital stuff. Fortunately, PostgreSQL provides easy means to create backups.
The following topics will be covered:
- Running pg_dump
- Partially dumping data
- Restoring backups
- Making use of parallelism
- Saving global data
At the end of the chapter, you will be able to set up proper backup mechanisms.
