The PostgreSQL High Availability course builds on the PostgreSQL Administration course, providing an insight into ways to tune, manage and extend your Postgres database to provide a highly available environment. Participants will learn the skills needed to ensure that their database achieves maximum throughput with minimum downtime. The PostgreSQL High Availability course is a valuable asset to administrators looking to enhance their environment to its full potential.

Audience: The module is suitable for IT Professionals, system administrators and GIS professionals.

Prerequisites: Completion of PostgreSQL Administration

Course outline:

  • What defines a Highly Available Environment?
  • High Availability Options
  • Streaming Replication
  • Clustering
  • Load Balancing / Connection Pooling
  • Deciding on the High Availability Solution for You
  • Implementation Workshop