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

Introduction

Secure and revive your PostgreSQL data with pgBackRest

Getting Started with PostgreSQL Backups

Introduction to backups in PostgreSQL
Introduction to restore in PostgreSQL

Getting Started with pgBackRest

Installing pgBackRest
Setting up the initial configuration
Setting passwordless SSH on dedicated backup hosts
Configuring the Stanza
Challenge - Setting up pgBackRest
Solution - Setting up pgBackRest

Performing Backups

Perform a backup - Full, incremental, and differential
Schedule a backup
Backup information
Challenge - Take backups using pgBackRest
Solution - Take backups using pgBackRest

Restoring Backups

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

Advance Configurations

Creating multi-repo and asynchronous archiving
Backup retention
Parallel backup and restore
Challenge - Remove backup manually
Solution - Remove backup manually

Conclusion

Continuing learning PostgreSQL and pgBackRest