Replication, Backup & Disaster Recovery
This class covers the basics of replication, backup and recovery through administration and application of design.
Prerequisites
- Basics of PostgreSQL
- PostgreSQL Database Administration
- Basics of Systems Administration
- Basics of Application Design
Topics
- Replication Overview
- Replication Terminology
- Replication Architecture
- Replication Startup & Setup
- Disconnection & Reconnection
- Switchover, Failover & Failback
- Physical Streaming Replication & Hot Standby
- repmgr
- Physical Backup
- Point In Time Recovery
- Barman
- Logical Backup
- Logical Replication Overview
- pglogical
- Built-in Logical Replication
- Logical Decoding
- Online Upgrade
- Bi-Directional Replication
- Acquired Skills
Acquired Skills
- PostgreSQL Database Administration
- PostgreSQL Database Architecture
- PostgreSQL Replication
- PostgreSQL High Availability
- PostgreSQL Disaster Recovery
- Basics of PostgreSQL Scalability
Business applications require high reliability of their backend database cluster. 2ndQuadrant’s PostgreSQL Solution for Single Master with High Availability addresses exactly that requirement, and is based on years of experience fulfilling enterprise needs.
Upcoming Training Courses
Formations à Londres, Royaume Uni
On hold until further notice due to COVID-19
Formations à Prato / Milan / Rome, Italie
On hold until further notice due to COVID-19
*Additional information:
- The course will be confirmed when three students are enrolled for the Prato office, while for the Milan and Rome offices the course will be confirmed when 4 students are enrolled.
- The registration fee includes: didactic material, 2 coffee breaks per day and lunch.
- Each participant must have a personal laptop.
Tags: PostgreSQL, Replication, Disaster Recovery, Backup
Length: 3.00 days