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

Prerequisiti Argomenti Capacità acquisite

• 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

Durata: 3.00 giorni

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).