Implementing High Availability in PostgreSQL Training Course

Course Code



7 hours (usually 1 day including breaks)


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


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



Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the US!

As a Business Development Manager you will:

  • expand business in the US
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!