15
Backup and Restore
It doesn’t matter how solid your hardware and software is – sooner or later, you will need to go back in time to recover accidentally deleted or damaged data. That is the purpose of a backup – to provide a safe copy that you can keep for a specific amount of time that allows you to recover from data loss. Being an enterprise-level database cluster, PostgreSQL provides a set of specific tools that allow a database administrator to take care of backups and restorations, and this chapter will show you all the main tools that you can exploit to be sure your data will survive any accidental abuse.
Backup and restore isn’t a very complex topic, but it’s fundamental in any production system and requires careful planning. In fact, ...
Get Learn PostgreSQL - Second Edition 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.
