Replication, Backup & Disaster Recovery

This course discusses in detail the various modes of replication, backup and recovery which are available or being developed on PostgreSQL, concentrating on technical aspects as well as on suitability for different use cases. Recommended for database administrators and system administrat

Prerequisites Topics Acquired skills

• Basics of systems administration

• Basics of PostgreSQL database administration

• PostgreSQL basics

• Basics of applications design with PostgreSQL

• Logical Backup

• Replication Overview

• Replication Terminology

• Replication Transport

• Replication Startup & Setup

• Disconnection and Reconnection

• Switchover, Failover and Failback

• Physical Streaming Replication

• repmgr

• Logical Streaming Replication & pglogical

• Bi-Directional Replication

• Logical Decoding

• Online Upgrade

• Connection Pooling

• Sharding and Scale Out

• Physical Backup

• Point In Time Recovery

• Barman

• Advanced PostgreSQL database administration

• Advanced database architecture techniques

• Basics of database replication with PostgreSQL

• Basics of database scalability with PostgreSQL

• Basics of high availability and recovery with PostgreSQL

Tags: Database Administration, Systems Administration, Business Continuity and Operations, DevOps

Code: PGREPEN
Length: 3.00 days

Upcoming related events


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.