Implementing High Availability in PostgreSQL Training Course

Duration

7 hours (usually 1 day including breaks)

Requirements

It is recommended to take this training only if you have a prior knowledge of PostgreSQL.

Overview

This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.

Course Outline

• Introduction
• Streaming Replication
  • Streaming Replication
  • Sync or Async
  • Cascaded Replication
  • Transaction Log Archiving 
  • Base Backups
  • Setup Streaming
  • Monitoring Streaming
  • Handling Conflicts
• High Availability Setup
  • Connection Pooling and HA setup using pgpool-II
    • Installation
    • Configuration
    • Pool Setup
    • HA Setup
  • Demos and Labs