<- Back to all courses

[DBA 3]

 PostgreSQL

Backups and Replication

🗓️ Dates: 9-13 February 2025

đź’» 5 live online sessions, 3h30m each

🎤 Includes: Q&A, theory and live demo

🏷️ Price: €850 before taxes

To participate in this course, you must either have completed [DBA2] PostgreSQL Advanced or possess equivalent hands-on experience.

For details see the course T&Cs.

The training is aimed at PostgreSQL DBA who already have solid operational experience and want to deepen their expertise in data protection, replication, and high availability strategies.

  • Manage backups with PITR tools
  • Maintain one or more standby servers
  • Replicate PostgreSQL data both physically and logically
  • Understand failover procedures
  • Be aware of the pitfalls of automated failover
Registration OPEN
What you'll learn

What You’ll Learn

This course is designed to equip you with the practical skills to manage PostgreSQL backups and replication for high availability and data protection. You’ll learn how to use PITR tools, maintain standby servers, set up physical and logical replication, and handle failover procedures — while understanding the risks and challenges of automated failover.

Tools for PostgreSQL backups

Understanding, comparing, and choosing the right backup solution for your needs

This chapter begins with a recap of point-in-time recovery (PITR) fundamentals to show why tooling is essential for reliable recovery. It then explores the main tools available for PostgreSQL backups, with a focus on their capabilities, differences, and practical use cases.

Highlights include:

  • Understanding why backup tooling is essential for reliable recovery
  • Overview of Barman, WAL-G, and pgBackRest
  • How each tool handles WAL archiving, encryption, compression, and incremental backups
  • Comparing features to choose the right fit for your infrastructure

Introduction to PostgreSQL replication mechanisms with a practical focus on setting up and managing a streaming standby.

This chapter explains PostgreSQL’s replication architecture, focusing on streaming replication and related physical, logical, and cascading replication concepts.

Highlights include:

  • Key replication terminology and patterns (asymmetric/symmetric, synchronous/asynchronous)
  • How WAL-based replication works, including log shipping and streaming
  • Step-by-step streaming replication setup (primary and standby)
  • Standby promotion, failover safety, and re-synchronisation
  • Monitoring replication health, lag, and conflicts
  • Preventing standby dropout with WAL archiving or replication slots

This chapter introduces PostgreSQL’s logical replication. It explains how logical decoding works, what can and cannot be replicated, and how to configure and operate publications and subscriptions.

Highlights include:

  • Key differences between physical and logical replication
  • Architecture, terminology, and the streaming process
  • Setup steps: creating publications and subscriptions
  • Supported granularity: by table, schema, row, or operation
  • Limitations (DDL, sequences, large objects) and how to work around them
  • Monitoring and troubleshooting replication errors
  • Using logical replication for major PostgreSQL upgrades

This chapter introduces the principles and best practices of high availability in PostgreSQL. It explains why availability matters, how to set clear objectives, and what compromises often arise between service continuity and data durability.

Highlights include:

  • Service vs. data availability and their trade-offs
  • RPO and RTO as key objectives to define
  • Backups, streaming replication, and automated failover as technical means
  • Risks of automation, such as split-brain and the added operational complexity following failover
  • Anti split-brain mechanisms: fencing, quorum, watchdog
  • Overview of major PostgreSQL HA solutions
  • Practical introduction to Patroni operations

Format and Schedule

This extensive PostgreSQL course consists of 5 live sessions (3h30m each), delivered over the course of five days.

To receive a certificate of attendance, participants must attend all five sessions.

  • Sessions will be conducted in English via Zoom.
  • Participants must have the latest version of Zoom installed on their computer.
  • Please note: Sessions will not be recorded.
  • The course format combines theoretical slides with live demos, led by the instructor in real time. Each session includes a live Q&A for direct interaction.
  • There are no scheduled breaks during the 3.5-hour sessions.

 

Cost: €850 before taxes.

Session Schedule

(all times CEST)

Monday,
9 February

10:00–13:30

 

Tuesday,
10 February

10:00–13:30

 

Wednesday,
11 February

10:00–13:30

Thursday,
12 February

10:00–13:30

 

Friday,
13 February

10:00–13:30

Register now!

Course duration: 5 days, 5 sessions; 3.5 hours each 

Course cost: €850 before taxes

Course Terms & Conditions

 

📝 Following the form submission: You’ll receive payment instructions via email.

💳 Payment Methods: Credit card or direct bank transfer.

⚠️ Important: Your spot is only confirmed once payment is received.

đź“© If you have any questions or issues, please contact us at [email protected]

By providing your information, you consent to its processing as described in our Privacy Policy and agree to receive updates and communications from Data Egret GmbH. You may withdraw your consent at any time.

Instructors

Thom Brown has worked in the industry for over 20 years. With many years of experience working with PostgreSQL, he has extensive expertise in supporting clients on their PostgreSQL journey, helping them achieve high availability for their business-critical projects.
Thom Brown
PostgreSQL Consultant

Stefan has close to 15 years of expertise in the database space, boasting extensive experience in client support, maintenance, and architectural consulting.
He is a recognised PostgreSQL contributor and a contributor to pgBackRest, a reliable backup and restore solution for PostgreSQL.

Stefan Fercot
Senior PostgreSQL Expert

© 2025 All Rights Reserved.