Table of Contents Previous Next


2 Failover Manager - Overview : 2.2 Prerequisites

If you provide a value in the script.notification property, you can leave the user.email field blank; an SMTP server is not required.
If an event occurs, Failover Manager invokes the script (if provided), and sends a notification email to any email addresses specified in the user.email parameter of the cluster properties file. For more information about using an SMTP server, visit:
During switchover, a recovery.conf file is copied from a random standby node to the stopped master. You should ensure that the paths within the recovery.conf files on your standby nodes are consistent.
You must modify the pg_hba.conf file on the Master and Standby nodes, adding entries that allow communication between the all of the nodes in the cluster. The following example demonstrates entries that might be made to the pg_hba.conf file on the Master node:
efm specifies the name of a valid database user.
fmdb specifies the name of a database to which the efm user may connect.
By default, the pg_hba.conf file resides in the data directory, under your Postgres installation. After modifying the pg_hba.conf file, you must reload the configuration file on each node for the changes to take effect. You can use the following command:
Where x specifies the Postgres version.
To prevent this, start the Failover Manager agent before starting the database server. The agent will start in idle mode, and check to see if there is already a master in the cluster. If there is a master node, the agent will verify that a recovery.conf file exists, and the database will not start as a second master.
If a Linux firewall (i.e. iptables) is enabled on the host of a Failover Manager node, you may need to add rules to the firewall configuration that allow tcp communication between the Failover Manager processes in the cluster. For example:
The command shown above opens a small range of ports (7800 through 7810). Failover Manager will connect via the port that corresponds to the port specified in the cluster properties file.
The database user specified in the efm.properties file must have sufficient privileges to invoke the following functions on behalf of Failover Manager:
Failover Manager uses the value returned by querying the current_setting function to ensure that the user specified in the db.user property has sufficient permissions; the function must return is_superuser. For detailed information about each of these functions, please see the PostgreSQL core documentation, available at:

2 Failover Manager - Overview : 2.2 Prerequisites

Table of Contents Previous Next