In Chapter 8, Managing PostgreSQL Security, we took a look at all we need to know about securing PostgreSQL in the most simplistic and most beneficial way possible. The topics undertaken in this chapter are 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 an easy means for creating backups.

Therefore, in this chapter, we will cover the following topics:

• Running pg_dump
• Partially dumping data
• Restoring backups
• Making use of parallelism
• Saving global data

At the end of this chapter, we will be able to set up proper backup mechanisms.