# Backup and Replication

> Logical and physical backup, WAL archiving, physical and logical replication, and cluster architectures.

---

LLMS index: [llms.txt](/en/llms.txt)

---

<!-- Generated by scripts/generate_skeleton.py. -->

This course keeps the official topic order and exposes the English handout as readable, native Markdown for review and future editorial work.

> **Source status:** 官方 PDF 已提取为原生 Markdown

> **Translation baseline:** English baseline. The current English archive is the working baseline; the Russian edition is retained for chapter-level cross-checking.

## Course scope

Logical and physical backup, WAL archiving, physical and logical replication, and cluster architectures.

## Source status

| Language | Current package | Version | Topics | Course page |
| --- | --- | --- | ---: | --- |
| English | [DBA3-handouts-16-en-20260917.zip](https://edu.postgrespro.com/16/DBA3-handouts-16-en-20260917.zip) | 16-20260917 | 9 | [HTTP 404](https://postgrespro.com/community/courses/DBA3) |
| Русский | [DBA3-handouts-16.zip](https://edu.postgrespro.ru/16/DBA3-handouts-16.zip) | 16 | 9 | [HTTP 200](https://postgrespro.ru/education/courses/DBA3) |

## Contents

- [00 PostgreSQL 16](/en/dba3/dba3-00-introduction/)
- [01 Logical Backup](/en/dba3/dba3-01-backup-logical/)
- [02 Base Backup](/en/dba3/dba3-02-backup-base/)
- [03 WAL Archive](/en/dba3/dba3-03-backup-archive/)
- [04 Physical Replication](/en/dba3/dba3-04-replica-physical/)
- [05 Switchover to Replica](/en/dba3/dba3-05-replica-switchover/)
- [06 Logical Replication](/en/dba3/dba3-06-replica-logical/)
- [07 Use Cases](/en/dba3/dba3-07-replica-usecases/)
- [08 Overview](/en/dba3/dba3-08-cluster-overview/)

## Supplementary materials

- `dba3_new_features.pdf`
- `dba3_student_guide.pdf`

## Editorial status

The available English handout is extracted from the official PDF. Where no current English archive was found, the route remains ready for a later source edition.

- [Version matrix](/en/versions/)
- [Work checklist](/en/checklist/)
- [Sources and permissions](/en/about/)

---

Section pages:

- [Lesson 00: Backup and Replication / PostgreSQL 16](/en/dba3/dba3-00-introduction/): Native Markdown source page: Backup and Replication / PostgreSQL 16
- [Lesson 01: Backup / Logical Backup](/en/dba3/dba3-01-backup-logical/): Native Markdown source page: Backup / Logical Backup
- [Lesson 02: Backup / Base Backup](/en/dba3/dba3-02-backup-base/): Native Markdown source page: Backup / Base Backup
- [Lesson 03: Backup / WAL Archive](/en/dba3/dba3-03-backup-archive/): Native Markdown source page: Backup / WAL Archive
- [Lesson 04: Replication / Physical Replication](/en/dba3/dba3-04-replica-physical/): Native Markdown source page: Replication / Physical Replication
- [Lesson 05: Replication / Switchover to Replica](/en/dba3/dba3-05-replica-switchover/): Native Markdown source page: Replication / Switchover to Replica
- [Lesson 06: Replication / Logical Replication](/en/dba3/dba3-06-replica-logical/): Native Markdown source page: Replication / Logical Replication
- [Lesson 07: Replication / Use Cases](/en/dba3/dba3-07-replica-usecases/): Native Markdown source page: Replication / Use Cases
- [Lesson 08: Clustering Technologies / Overview](/en/dba3/dba3-08-cluster-overview/): Native Markdown source page: Clustering Technologies / Overview