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

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

Code: PGREPEN
Length: 3.00 days

Upcoming related events


Tieniti in contatto con noi.

Iscriviti alla nostra newsletter trimestrale: riceverai le ultime notizie su 2ndQuadrant e aggiornamenti sulle tecnologie da noi supportate

La tua privacy è tutelata in base alla normativa vigente (art. 13 D. Lgs. 30.06.2003, n. 196).