Advanced PostgreSQL Database Administration
- Buy now
- Learn more
Course Materials (Downloadable)

Activity-Guide-v5.0
Slides-v2.0
Introduction to the Course

Replication Concepts
Preparing the System for Lab Practices

Link to download Pre-built VMs
Initial System Setup
File-based Replication

About File-based Replication
Hands-on: File-based Replication
Streaming Replication

About Streaming Replication
Hands-on: Converting File-base Replication to Aynchronous Streaming Replication
Hands-on: Configuring Asynchronous Streaming Replication from Scratch
About Synchronous Streaming Replication
Hands-on: Configuring Synchronous Streaming Replication
Configuring Multiple Standbys
Hand-on: Configuring Multiple Standbys
Logical Replication

About Logical Replication
Hands-on: Implementing Logical Replication
Internals and Tuning of Shared Buffers

Internals of Shared Buffers
Hands-on: Internals and Tuning of Shared Buffers
Internals and Tuning of Work Memory

Tuning Work Memory
Internals and Tuning of Maintenance Work Mem

About Maintenance Work Memory and Vacuuming
Hands-on: Vacuum in action
About Autovacuum and Tuning Autovacuum

File-based Replication

2 Lessons