+39 0574 159 3000Replication, 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
- 4 Mar 2020 – 6 Mar 2002 | Prato (PO) / Milano (MI) / Roma (ROMA), Italy*
- 12 May 2020 – 14 May 2020 | London, United Kingdom
- 20 May 2020 – 22 May 2020 | Prato (PO) / Milano (MI) / Roma (ROMA), Italy*
- 14 Oct 2020 – 16 Oct 2020 | Prato (PO) / Milano (MI) / Roma (ROMA), Italy*
*Additional information:
- The course will be delivered in Italian language.
- 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
