PostgreSQL Backup and Restore with pgBackRest

Course details

The demand for OpenSource tools and technologies is increasing, and people are looking to upskill on more open source tools. In this course, PostgreSQL expert Sonia Valeja introduces you to using pgBackRest, one of the popular backup and restore tools in the PostgreSQL market. Learn how to get started with PostgreSQL backups and pgBackRest, then dive into both performing backups and restoring backups. Plus, explore advanced configurations like creating multi-repo and asynchronous archiving, as well as parallel backups and restores. Each chapter comes with a practical, hands-on challenge and highlights one possible solution to the challenge.

Concepts

0. Introduction

01 - Secure and revive your PostgreSQL data with pgBackRest

1. Getting Started with PostgreSQL Backups

02 - Introduction to backups in PostgreSQL
03 - Introduction to restore in PostgreSQL

2. Getting Started with pgBackRest

04 - Installing pgBackRest
05 - Setting up the initial configuration
06 - Setting passwordless SSH on dedicated backup hosts
07 - Configuring the Stanza
08 - Challenge - Setting up pgBackRest
09 - Solution - Setting up pgBackRest

3. Performing Backups

10 - Perform a backup - Full, incremental, and differential
11 - Schedule a backup
12 - Backup information
13 - Challenge - Take backups using pgBackRest
14 - Solution - Take backups using pgBackRest

4. Restoring Backups

15 - Restoring a backup - Full, incremental, and differential
16 - Restoring delta changes
17 - Restoring selected database
18 - Point-in-time recovery (PITR)
19 - Challenge - PITR using LSN number
20 - Solution - PITR using LSN number

5. Advance Configurations

21 - Creating multi-repo and asynchronous archiving
22 - Backup retention
23 - Parallel backup and restore
24 - Challenge - Remove backup manually
25 - Solution - Remove backup manually

Conclusion

26 - Continuing learning PostgreSQL and pgBackRest

PostgreSQL Backup and Restore with pgBackRest

Authors

Sonia Valeja