2ndQuadrant | PostgreSQL
Mission Critical Databases
+39 0574 159 3000
  • Contact us
  • IT
    • EN
    • FR
    • ES
    • DE
    • PT
  • Supporto e Servizi
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case per il Supporto su PostgreSQL
      • BDR
    • Case Studies
      • Migrazione del Database
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Tuning delle prestazioni
        • BenchPrep
        • tastyworks
      • Cluster distribuiti di database
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Aggiornamento del Database
        • Alfred Wegener Institute (AWI)
      • Supporto e Amministrazione del Database
        • Met Office
        • Agilis Systems
        • London & Partners
  • Centro di Apprendimento PostgreSQL
    • Webinars
      • Archivio Webinar
    • Whitepapers
      • Business Case per il Supporto su PostgreSQL
      • Buone prassi per la sicurezza
    • Blog
    • Formazione Professionale
      • Catalogo dei corsi
    • Case Studies
      • Tuning delle prestazioni
        • BenchPrep
        • tastyworks
      • Cluster distribuiti
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Amministrazione del Database
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Aggiornamento del Database
        • Alfred Wegener Institute (AWI)
      • Migrazione del Database
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Libri
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2 Edizione
      • PostgreSQL 9 Administration Cookbook – 3 Edizione
      • PostgreSQL Server Programming Cookbook – 2 Edizione
      • PostgreSQL 9 Cookbook – Edizione in lingua Cinese
    • Video
    • PostgreSQL
      • PostgreSQL – La storia
      • Chi usa PostgreSQL?
      • PostgreSQL FAQs
      • PostgreSQL vs MySQL
      • Business Case per PostgreSQL
      • Informazioni di Sicurezza
      • Introduzione a PostGIS
      • Documentazione
  • Chi siamo
    • Chi è 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • Notizie
    • Lavora con noi
  • Blog
  • Installers
  • Menu Menu
Sei in: Home1 / Training2 / Replication, Backup & Disaster Recovery

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

PostgreSQL with High Availability

Highly Availability

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

Trainings in London, United Kingdom

On hold until further notice due to COVID-19

Trainings in Prato / Milano / Roma, Italy

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

Back to PostgreSQL Training
  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scorrere verso l’alto
×