© Baji Shaik 2020
B. ShaikPostgreSQL Configurationhttps://doi.org/10.1007/978-1-4842-5663-3_4

4. Backup and Restore Best Practices

Baji Shaik1 
(1)
Hyderabad, Andhra Pradesh, India
 

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 ...

Get PostgreSQL Configuration: Best Practices for Performance and Security 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.