Failover Manager with client connect failover

Most of the PostgreSQL connection libraries supportclient connection failover. These libraries support connection stringswith more than one database server. On first connection attempt or when the connection is lost(which also occurs during a failover), the client driver connects to the supplied hosts one by one until it finds a read-write connection.The time for reconnecting to the newmaster depends on the connection timeouts as configured inthe driver and TCP layer.

Figure 2: Failover Manager’s traffic routing using client connect failover

Using Failover Manager with Client Connection failover

Installing

Install and configure Advanced Server and Failover Manager on three servers as follows: