BEGIN:VCALENDAR VERSION:2.0 METHOD:PUBLISH CALSCALE:GREGORIAN PRODID:-//WordPress - MECv5.5.0//EN X-ORIGINAL-URL:https://osb-alliance.de/ BEGIN:VEVENT UID:MEC-4a7a6fd7f3d34d4310e1b705b86364db@osb-alliance.de DTSTART:20260209T070000Z DTEND:20260213T170000Z DTSTAMP:20251231T181300Z CREATED:20251231 LAST-MODIFIED:20260126 SUMMARY:PostgreSQL Backups and Replication (DBA3) – Data Egret DESCRIPTION:🗓️ Dates: 9-13 February 2026 💻 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 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 Streaming Replication in PostgreSQL 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 Logical Replication in PostgreSQL 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 High Availability and automated failover best practices 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 CET) 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 URL:https://osb-alliance.de/veranstaltungen/postgresql-backups-and-replication-dba3-data-egret ORGANIZER;CN=Data Egret GmbH:MAILTO: LOCATION:Online-Veranstaltung ATTACH;FMTTYPE=image/png:https://osb-alliance.de/wp-content/uploads/2025/12/DBA3-OSBA.png END:VEVENT END:VCALENDAR