Backup Best Practices with pgBackRest
Presented by:
David Steele
David Steele is Principal Architect at Crunchy Data, the Trusted Open Source Enterprise PostgreSQL Leader. He has been actively developing with PostgreSQL since 1999.
David loves taking on big data challenges. Before Crunchy Data he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.
David's current project is pgBackRest, which will be the subject of this talk.
Backups are a critical part of any enterprise database solution but they are often done poorly or skipped altogether, which can lead to data loss in the event of hardware failure or some other disaster. With the proper tools and procedures data loss can be minimized or entirely avoided, saving valuable enterprise data and time.
In this talk we'll cover database backup best practices and how to implement them with pgBackRest, including:
- WAL archiving
- Backup frequency and retention
- How to meet recovery time/point objectives
- Configuration options
- Performance considerations
- Restore testing
- Date:
- 2020 November 20 10:30 CST
- Duration:
- 40 min
- Room:
- Virtual - English Sub-Conference B
- Conference:
- CHINA 2020 And PGConf.Asia 2020
- Language:
- Track:
- Backup and Restores
- Difficulty:
- Medium