Backup and Restore Best Practices

In the last chapter, we talked about user management in PostgreSQL using roles by assigning proper privileges and secure data by encrypting using the pgcrypto module. It helps to improve security by controlling object and data access. In this chapter, we are going to talk about backup/restore strategies and procedures. Building these strategies needs a lot of information. This chapter walks you through the stages in which information will be gathered to set up backup/restore for a database, based on the criticality of the data. This chapter also talks about when to/what to/ how to backup/restore.