PostgreSQL Administration 16. Backup and Replication

Course ID : PS-DBA3

Duration In-class (в days) : 2 days

Duration Online : 2 days

Сurriculum : Virtual Instructor-Led Training - ONLINE

Overview

This course covers logical and physical data backup and recovery, redo log archiving, logical and physical replication, and an overview of cluster technologies.

Audience for this course

Database Administrators

Prerequisites for this course

Outcomes

By completing this course, students will have acquired the skills to:

    • Perform backups using various methods
    • Configure servers for physical and logical replication
    • Understand replication use cases
    • Understand clustering techniques

Outline

Module 1. “Backup”

  • Logical Backup
  • Basic Backup
  • Write-Ahead Log Archive

Lab Work

  • Create a copy of global objects and cluster databases. Restore a cluster to another server.
  • Work with a base backup, take into account the use of user tablespaces.
  • Restore from a backup with an archive to a specified target time.

Module 2. “Replication”

  • Physical Replication
  • Fail over to a Replica
  • Logical replication
  • Use scenarios

Lab Work

  • Configure physical streaming replication, studying the impact of feedback and the presence of a replication slot.
  • Simulate a system failure, failover to a replica. Reactivating the former primary server.
  • Implement logical data replication across different databases within a single cluster.
  • Implement a cascade replication scenario.

 Module 3. “Cluster Technologies”

  • Overview

Ask question