Replication, Backup & Disaster Recovery

This class covers the basics of replication and recovery, through administration and application of design.

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

Length: 3.00 days
Price: £ 1500

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.