Module 11 - Backup, Recovery and PITR

Module Objectives

Types of Backup

Database SQL Dump

pg_dump Options

Demo - SQL Dump Backups

SQL Dump - Large Databases

Restore - SQL Dump

pg_restore Options

Demo - SQL Dump Restore

Entire Cluster - SQL Dump

pg_dumpall Options

Demo - Cluster Dump

Backup - File System Level Backup

Demo - Offline Filesystem Level Backups

Backup - Continuous Archiving

pg_receivexlog

Continuous Archiving

Demo - Continuous Archiving

Base Backup Using Low Level API

Base Backup Using pg_basebackup Tool

Options for pg_basebackup

pg_basebackup - Online Backup

Demo - On Line Base Backups

Point-in-Time Recovery

Performing Point-in-Time Recovery

Point-in-Time Recovery Settings

Demo - Point-in-Time Recovery

EDB Backup and Recovery Tool

Module Summary

Lab Exercise - 1

Lab Exercise - 2

Lab Exercise - 3

Lab Exercise - 4

Lab Exercise -5

Lab Exercise -6