Postgres as a Service
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
Upgrading an Existing Cluster¶
Failover Manager provides a utility to assist you when upgrading a Failover Manager cluster. To upgrade an existing cluster, you must:
Install Failover Manager 3.6 on each node of the cluster. For detailed information about installing Failover Manager, see Installing Failover Manager
After installing Failover Manager, invoke the
efm upgrade-confutility to create the
.nodesfiles for Failover Manager 3.6. The Failover Manager installer adds the upgrade utility (efm upgrade-conf) to the
/usr/edb/efm-3.6/bin directory. To invoke the utility, assume root privileges, and invoke the command:
efm upgrade-conf <cluster_name>
upgrade-confutility locates the
.nodesfiles of pre-existing clusters and copies the parameter values to a new configuration file for use by Failover Manager. The utility saves the updated copy of the configuration files in the
.nodesfiles for EFM 3.6, specifying any new preferences.
Use your choice of editor to modify any additional properties in the properties file (located in the
/etc/edb/efm-3.6directory) before starting the service for that node. For detailed information about property settings, see The Cluster Properties File .
As of version 3.6,
db.bin is a required property. When modifying the properties file, ensure that the
db.bin property specifies the location of the Postgres
Use a version-specific command to stop the old Failover Manager cluster; for example, you can use the following command to stop a version 3.5 cluster:
/usr/efm-3.5/bin/efm stop-cluster efm
Start the new Failover manager service (
efm-3.6) on each node of the cluster.
The following example demonstrates invoking the upgrade utility to
.nodes files for a Failover Manager
[root@one ~]# efm upgrade-conf example Checking directory /etc/edb/efm-3.5 Processing example.properties file Checking directory /etc/edb/efm-3.5 Processing example.nodes file Upgrade of files is finished. The owner and group for properties and nodes files have been set as 'efm'. [root@one ~]#
If you are using a Failover Manager configuration without sudo,
-source flag and specify the name of the directory in which the
configuration files reside when invoking
upgrade-conf. If the directory is not
the configuration default directory, the upgraded files will be created in the directory
from which the
upgrade-conf command was invoked.
Please note: If you are using a custom service script or unit file, you must manually update the file to reflect the new Failover Manager service name when you perform an upgrade.
Un-installing Failover Manager¶
After upgrading to Failover Manager 3.6, you can use Yum to remove previous installations of Failover Manager. For example, use the following command to remove Failover Manager 3.6 and any unneeded dependencies:
yum remove edb-efm36
Performing a Database Update (Minor Version)¶
This section describes how to perform a quick minor database version upgrade. You can use the steps that follow to upgrade from one minor version to another (for example, from 10.1.5 to version 10.2.7), or to apply a patch release for a version.
You should first update the database server on each Standby node of the Failover Manager cluster. Then, perform a switchover, promoting a Standby node to the role of Master within the Failover Manager cluster. Then, perform a database update on the old master node.
On each node of the cluster you must perform the following steps to update the database server:
- Stop the Failover Manager agent.
- Stop the database server.
- Update the database server.
- Start the database service.
- Start the Failover Manager agent.
For detailed information about controlling the Advanced Server service, or upgrading your version of Advanced Server, please see the EDB Postgres Advanced Server Guide, available at:
When your updates are complete, you can use the efm set-priority command to add the old master to the front of the standby list, and then switchover to return the cluster to its original state.