EDB Failover Manager™

EDB Failover Manager™

EDB Postgres Failover Manager (EFM) is a high-availability module from EnterpriseDB that enables a Postgres Master node to automatically failover to a Standby node in the event of a software or hardware failure on the Master.

This guide provides information about installing, configuring and using Failover Manager 3.7.

This document uses Postgres to mean either the PostgreSQL or EDB Postgres Advanced Server database. For more information about EDB Postgres products, please visit the EnterpriseDB website .

• What’s New
• Failover Manager Overview
  • Supported Platforms
  • Prerequisites
  • Tutorial - Configuring a Simple Failover Manager Cluster
• Installing Failover Manager
  • Installing Failover Manager on a RedHat, CentOS, or OEL Host
    • Installation Locations
  • Installing Failover Manager on a Debian or Ubuntu Host
  • Installing Failover Manager on a SLES Host
• Configuring Failover Manager
  • The Cluster Properties File
    • Specifying Cluster Properties
  • Encrypting Your Database Password
  • The Cluster Members File
  • Extending Failover Manager Permissions
    • Running Failover Manager without sudo
  • Using Failover Manager with Virtual IP Addresses
• Using Failover Manager
  • Managing a Failover Manager Cluster
    • Starting the Failover Manager Cluster
    • Adding Nodes to a Cluster
    • Changing the Priority of a Standby
    • Promoting a Failover Manager Node
    • Stopping a Failover Manager Agent
    • Stopping a Failover Manager Cluster
    • Removing a Node from a Cluster
  • Running Multiple Agents on a Single Node
    • RHEL 6.x or CentOS 6.x
    • RHEL 7.x or CentOS 7.x
• Monitoring a Failover Manager Cluster
  • Reviewing the Cluster Status Report
  • Monitoring Streaming Replication with Postgres Enterprise Manager
• Using the efm Utility
• Controlling the Failover Manager Service
  • Using the service Utility on RHEL 6.x and CentOS 6.x
  • Using the systemctl Utility on RHEL 7.x and CentOS 7.x
• Controlling Logging
  • Enabling syslog Log File Entries
• Notifications
• Supported Failover and Failure Scenarios
  • Master Database is Down
  • Standby Database is Down
  • Master Agent Exits or Node Fails
  • Standby Agent Exits or Node Fails
  • Dedicated Witness Agent Exits / Node Fails
  • Nodes Become Isolated from the Cluster
• Upgrading an Existing Cluster
  • Un-installing Failover Manager
  • Performing a Database Update (Minor Version)
• Troubleshooting
• Configuring Streaming Replication
  • Limited Support for Cascading Replication
• Configuring SSL Authentication on a Failover Manager Cluster
• Conclusion